Calculation with hours

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

I need to add hours, where the result appears according to example below:
15:32 + 17:45 = 33:17

ps.: I already tried in the format of abbreviated hour and I didn't get.
 
Frank Dulk said:
I need to add hours, where the result appears according to example below:
15:32 + 17:45 = 33:17

ps.: I already tried in the format of abbreviated hour and I didn't get.
Click to expand...

Access doesn't have any such built-in handling for time durations. The DateTime
DataType is meant for storing "points in time", not "amounts of time". It can
actually do the latter, but it will always use dates for all of the chunks greater
than 24 hours and only use a Time format for what is left.

Generally for durations you are better off to store the interval you need as a long
integer (number of seconds or minutes) and then use an expression or custom function
to display it as Hours and Minutes.
 
Back
Top