Time Calculations

[James Mitchell]

I have set up a 'simple' database for inputting times
spent on jobs and created a query whereby an individuals
statistics can be calculated for a month. The problem lies
in that when the database sums the times for the various
tasks, if the sum is greater than 24hours, the 'clock'
resets itself instead of producing a running total.ie
56:27:02.

Currently for example if two times ie 23:00:00 and 2:00:00
are summed, the result is displayed as 01:00:00 instead of
25:00:00

Any ideas?

 

[Allen Browne]

The simplest solution is probably to convert the times to minutes, and then
display the result as desired. Details in article:
Calculating elapsed time
at:
http://members.iinet.net.au/~allenbrowne/casu-13.html