How do i calculate duration between datetime values in Access?

  • Thread starter Thread starter stanich
  • Start date Start date
S

stanich

I'm trying to calculate the difference (duration in minutes would be fine)
between two datetime colums. Or simply extract the time from each field and
calculate the difference between times making the assumption that the dates
are the same.

Any help will be appreciated. Thanks.
 
In a query something like below should return whole minutes. Put in the
correct field names:

TheMinutes: DateDiff("n",[FirstDate], [SecondDate])
 
Back
Top