How do I get the different between two time values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to find the different between two time values in Ms Access. I don't
know the way to do that.
 
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
 
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.
 

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

Similar Threads

Complex query 0
Pivot table macro filter data between yesterday and today (date+time) 0
Calculating the Difference between two times/ dates 4
Calculate difference between two dates,but not weekends 3
Selecting between two values in a query 6
How do i calculate duration between datetime values in Access? 1
Calculate difference between successive records in the same field 1
Macro to insert a line when a value changes in a range 1

Back
Top