Times Addition

D

Douglas J. Steele

The Date data type in Access is intended for timestamps, not durations.

Rather than attempting to add durations in that manner, you should store the
durations as Long Integers (either as total seconds or total minutes,
depending on what resolution you require) and add them together.
 
P

Pieter Wijnen

answer: just add them together
8:00+2:00+3:00
If they contain a datepart you can use
Time(Date1) + Time(Date2) + Time(Date3)
whickh is sufficient if the result is less than 24:00

Pieter
 
Top