Jump to content

Calculating Time

Recommended Posts

I am trying to figure out the best way to calculate a students attendance time.

I have created four fields:

Time_In_Hour, Time_In_Minutes, Time_Out_Hour and Time_Out_Minutes

I have the the default values of:

Time_In_Hour = 8 Time_In_Minutes = 15 (This represents 8:15 AM)

Time_Out_Hour = 2 Time_Out_Minutes = 15 (This represents 2:15 PM)

I have these as the default values but the teacher can change both times if the student comes in late or leaves early. I want to be able to report for each student the number of minutes attended per day based on a 6 hour day.

Would very much appreciate any help ! :?

Link to comment
Share on other sites


I have a suggestion here, but I have not tested it myself :) .

Use virtual fields in the Submission form to input time, then concatenate with date and input into the actual date/time field (get help from http://howto.caspio.com/datapages/creat ... parts.html). To display time use virtual field receiving the field value with proper Localization. I hope that helps :D

Link to comment
Share on other sites

What is the Data Type of the fields: Time_In_Hour, Time_In_Minutes, Time_Out_Hour and Time_Out_Minutes? Have you already built the Submission Form?

If the web form is already submitted and the data is present in the Table, then you can generate a Report DataPage based on the Table, http://howto.caspio.com/datapages/creat ... -datapage/

Calculated Field is an Advanced Reporting feature, please refer to this article: http://howto.caspio.com/datapages/creat ... ed-fields/

You can use the datediff function to calculate the time difference.

Few examples of how to use the datediff function is here:

http://howto.caspio.com/faq/reports-dat ... dates.html

http://howto.caspio.com/faq/time-and-da ... erson.html

Link to comment
Share on other sites

First of all, thanks so much for taking the time to respond. It is very much appreciated. I have built the form but it is not in full use yet. I was hoping to get advise as to the best practice for tracking time . I need to be able to report the percentage of time the student was present based on a 6 hour day.

The fields are text 255. I just read your last response, I will attempt to utilize your suggestions over the weekend. Once again, thanks so much for helping !

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...