Accountability Posted May 1, 2013 Report Share Posted May 1, 2013 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 ! :? Quote Link to comment Share on other sites More sharing options...
Bangalore Posted May 3, 2013 Report Share Posted May 3, 2013 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 Quote Link to comment Share on other sites More sharing options...
Bangalore Posted May 3, 2013 Report Share Posted May 3, 2013 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 Quote Link to comment Share on other sites More sharing options...
Accountability Posted May 4, 2013 Author Report Share Posted May 4, 2013 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 ! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.