Time Adding and Subtracting(this should be simple)

T

TwinDad

Good Day all,

This should be simple but i cant figure it out! I have a Times in and out
and need to calculate time span in-between.

(i.e. 08:00 to 13:00) this should equal 5:00.

I have tried DATEADD is there something that I am missing?

Thanks in advance,

- The Novice
 
J

John Spencer

Well, DateDiff is used to calculate differences in datetimes. DateAdd adds
a specified amount of time to a datetime field.

DateDiff("n",FirstDateTime,SecondDateTime) will return the number of minutes
between the two. Then you can do some math to change that to hours and
minutes.
 
T

TwinDad

Thank you John, That did work...

John Spencer said:
Well, DateDiff is used to calculate differences in datetimes. DateAdd adds
a specified amount of time to a datetime field.

DateDiff("n",FirstDateTime,SecondDateTime) will return the number of minutes
between the two. Then you can do some math to change that to hours and
minutes.
Click to expand...
 
Top