adding three fields with time values

[Bren]

Hi I have three boxes with time values in them ( ie 23:15, 00:15, 01:15) in
the fourth list box I want to total the lenght of time. Currently the form
is displaying the result as a time in the next day (i.e 00:45) instead of the
answer 24:45.

 

[Ken Snell MVP]

I assume that your time values are not times of the day, but rather are
elapsed minutes and seconds time (such as for a race or timed event)?

If yes, you should not be storing them in a DateTime field because they are
not DateTime values. Instead, you should store them in a Long Integer field
after you convert the hh:nn value into the total number of minutes. Then you
could add the minutes from each field, and then convert the result back to
the hh:nn format that you want for display.

For display, you'll not want to format the textbox as any type of date
format. Instead, the result should be a string value.