Time Calculations

[Bob]

How can I calculate and display times greater than 24
hours. I have a table collating hours worked and need to
be able to display the totals in an hours:minutes format.
However, any value greater than 23:59 returns false times.

 

[Duane Hookom]

You didn't suggest how you are storing hours worked. I suggest you us a
double precision number and store 8 Hrs 45 minutes as 8.75. However, if you
are using a datetime field to store a duration of time, try the following
expression:
Int(datTimeField*24) & ":" & Format(datTimeField,"hh:nn")

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

The article explains why this occurs, and how to work around it.