Problem with time over 24 hours

[rloibl]

Hello
I have the problem in MS-Access when I want to sum up fields with format "Time" and the counted values gave a time that goes over 24 hours because than it´s starts counting by zero again to 24.
In Excel there is the chance to say that he shouldn´t stop at 24 and count all up but I haven´t found this function in Access.

Thanks and regards
Robert

 

[MichaelRed]

AFAIK, it doesn't exist in Ms. A. Since date/time is stored as a 'floating point' value in all Ms. Speak, it is easy to do, if you are just adding time values. The number of days is just the Integer part of the sum, with the hh:mm:ss in the decimal part.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over