Time Addition over 24 Hours

[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

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

 

[Chipcom]

How to add for example:

245:36+159:43 ?


Thanks

 

[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.

 

[Larry Linson]

How to add for example:

245:36+159:43 ?

It would appear that you are trying to use a Date/Time variable or Field as
something other than what it is: a representation of a point in time... date
and time. If you want to deal with hours and minutes as numeric entities,
you should keep them in a numeric field, probably separately, though you
could convert the minutes to a fraction of hours.

Larry Linson
Microsoft Access MVP