How do i calculate duration between datetime values in Access?

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.
 
J

Jerry Whittle

In a query something like below should return whole minutes. Put in the
correct field names:

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