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
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"James Mitchell" wrote in message
...
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?