time duration

Question

Good morning ,&nbsp;
I currently have a&nbsp;
Resource Check In Date - Date field
Resource Check In Time - Time of day
Resource Check Out Date - Date
Resource Check Out Time - Time of day
Total Hrs -&nbsp; Duration field ([Resource Check In Time]-[Resource Check Out Time])
Currently the results duration times are incorrect. How do i have it calculate the total hrs, and also anytime there is a checkin after midnight the results are a negative number. Also the results should roung to the nearest minute. The results are showing 8 decimal points (20.3333333333333 hours).

Hopefully someone can help me.
------------------------------Dell Delemar------------------------------

donlarson · Answer

There are settings on the Formula field to control this
------------------------------Don Larson------------------------------

markshnier__you · Answer

I will tag team with my buddy Don.&nbsp; Don gave you the answer on that rounding issue.

The problem with the negatives for crossing midnight can be solved by subtracting not your time fields but a date time field (or calculation).
I will use formula variables to create a temporary field in the formula box for the date times of the check-in and checkout&nbsp;&nbsp;

var datetime CheckIn = ToTimeStamp([Resource Check In Date], [Resource Check In Time]);
var datetime CheckOut = ToTimeStamp([Resource Check Out Date], [Resource Check out Time]);

$CheckOut - $CheckIn------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

delldelemar · Answer

Thanks i found the decimal location after this message.&nbsp;------------------------------Dell Delemar------------------------------

delldelemar · Answer

Thank you that worked perfect. I will work on fixing the times that start after midnight.&nbsp;------------------------------Dell Delemar------------------------------

donlarson · Answer

Thank you Mark for answering the whole question!&nbsp;
I went brain dead after the easy part.------------------------------Don Larson------------------------------

Forum Discussion

time duration