HELPS - determine the time difference between the starttime and the endtime

[KennieN]

Hi all, I am trying to calculate the time difference between the Start and stop,

Dont know if access have this function or but cant find it, it is similiar to the function "datediff"

This is what i want to do in a query
Example:
Start Time:11:00AM, End Time:11:30AM, Total Time
I need to get the Total Time



I already have Start and End fields and their format are date/time (medium time) i have tried this in a query, but the the result come out incorrect

* Total Time:[End Time]-[Start Time]


Thanks in advance

 

[charityg]

Total: DateDiff("n",[End Time],[Start Time])

This will give you the difference in minutes.

 

[KennieN]

Thanks charityg

It's working, i try to use "h" interval argument to convert to hours, but the number turned out weird, i finnally used

AdminTimeTotal: DateDiff("n",[AdminTimeStart],[AdminTimeStop])/60


Thank you very much...