View Single Post
  #1  
Old April 28th, 2004, 01:54 PM
James Mitchell
external usenet poster
 
Posts: n/a
Default Time Calculations

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?