Time Addition over 24 Hours

C

Chipcom

Hi

I need to know how to add times like this examle:
[r]=[t1]+[t2]
33:30:03=10:20:02+23:10:01

Thanks
 
A

Allen Browne

What are those numbers?

They are not date/time values, because Access cannot display that many
hours/minutes/whatever, so I assume they are text strings. You cannot add
text strings up.

Please refer to the suggested article in the previous reply:
http://allenbrowne.com/casu-13.html

You can get a true number (e.g. of minutes) to add, and then see how to
display the result as a text string if you need to.
 
Top