Time Adding and Subtracting(this should be simple)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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...
 
Back
Top