Microsoft Access Date/Time Differences
How Much Time Has Elapsed Between Two Dates/Times. Employee Timesheets.
Q: I have a timesheet table with TimeIN and TimeOUT for
each employee. How can I calculate the HoursWorked?
A: Working with times and
dates in Access is easy once you know that each DAY has a value of ONE.
So if you add 1 to 1/1/1990, you get 1/2/1990. If you add 0.5 to
1/1/2004 you get 1/1/2004 12:00 (which is HALF a day). If you need to
figure out the difference between two times, just subtract them. That
will give you the difference IN DAYS between those two dates. If it's a
fraction, you're dealing with HOURS, just multiply by 24. Here's an
example:
Here is a FREE VIDEO TUTORIAL
that will walk you through an example of working with date and time
differences. It's
much easier to show you how it's done than to explain it here.
I teach the concepts in this free mini tutorial in my
Access 206 course. These are
full courses - over 60 minutes in length each. I spend a lot more time going
over how to do this, in addition to lots more tips and tricks.
>>> Also, see my other Tip on
calculating the number of months
someone has been alive using the DateAdd and DateDiff
functions.
| 
