Time Calculations

  • Thread starter Thread starter Bob
  • Start date Start date
B

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.
 
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")
 
Back
Top