how do I calculate time in access? ex: time in time out

  • Thread starter Thread starter Missie
  • Start date Start date
M

Missie

Trying to keep track of time off request......need to get the difference in
the time the employee leaves and the time they get back using a query
 
Trying to keep track of time off request......need to get the difference in
the time the employee leaves and the time they get back using a query
Click to expand...

You can use the DateDiff function to calculate this.
For example DateDiff("n";TimeIn;TimeOut) calculates the difference in
minutes.

Groeten,

Peter
http://access.xps350.com
 
Back
Top