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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top