Time field for calculating past midnight

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

Guest

There were some instructions on here but I didn't understand how to put the
date and time to calculate total minutes between the interval. I have two
fields in my data base. Time and then date for a set of 6 different numbers.
I want to have access calculate the differences between two times that may
occur on different dates. How do I do this?
 
You can add the date field and the time field together, and then use the
DateDiff function to calculate the difference between two date/time values.

ElapsedMinutes = DateDiff("n", [DateField1] + [TimeField1], [DateField2] +
[TimeField2])
 
Back
Top