Calculating Time

[Accountability]

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 ! :?

[Bangalore]

Hello,

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

[Bangalore]

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

[Accountability]

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 !