How do I get the different between two time values?

N

Neranjala

I want to find the different between two time values in Ms Access. I don't
know the way to do that.
 
N

Neranjala

I have create a data base for attendance of our office. now i want to find
their office hours by using the diferrent of the time arrival & the time
departure?

Can you help?

Thanks in advance.


Neranjala
 
A

Allen Browne

You can use DateDiff(), but I recommend you read the article I posted in
reply to your various questions, so you understand how to get and interpret
the result and avoid problems with times > 24 hrs.
 
Top