Discussion Locked

calculate time periods in MS Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have help desk records in MS Access table. Fields:User request time.Response time.
(format style = 09:15)
How can I calculate the time elapsed between request and response, even though the reponse may be days later? How do build a query?

3 replies

by whw

SELECT DateDiff("h",[time1],[time2]) AS diff
FROM Table1;

This will show the hours between time1 and time2.

You might find the help files in access useful to explain the datediff function.

by colirussell

it worked but did not let me calculate minutes. Couldn't find a way to integrate "h" (hours) with "n" (minutes)in the formula.

This discussion is closed to new replies.