Calculating times in a form using hh:nn:ss

[markswan20]

Hi everyone,



I have looked at a few different posts relating to my question but I'm struggling to adapt what I've found to facilitate my requirement.

I have a basic table that has 3x fields time1 - time2 -time3 all using the data type date/number with input mask 00:00:00

The user enters a time as format hh:nn:ss

Example

time1 10:29:10
time2 00:12:01
time3 21:32:51

How would i create a field within the form to auto calculate the 3 values to add up to equal the total of 32:14:02

Thanks in advance

[Welshgasman]

Have you tried to add them?

[Micron]

is this one that you tried?
https://www.simply-access.com/Adding-Times.html

[CJ_London]

the time format is for hours in a day - so a maximum of 23 hours (24 hours takes you to the next day)

32 hours is greater than a day so when you add them you will get

1 Day 8 hours.....

so to return 32 you could try this

?format(datediff("h",#00:00:00#,#10:29:10# + #00:12:01# + #21:32:51#),"00:") & format(#10:29:10# + #00:12:01# + #21:32:51#,"nn:ss")
32:14:02