Calculate Time

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a form that shows the Employees loginTime and logoffTime with a
medium time format.
The Employee clocks in and then out.
I need to calculate the total time for that employee from this form.
The (2) controls are loginTime and logoffTime.
I have an unbound control on the form to calculate this.
The unbound control is named employeetime.
How can I make it perform the calculation ?
That is, add up the total time in hour format ?

Thanks,

Dave
 
How can I make it perform the calculation ?
That is, add up the total time in hour format ?
Click to expand...

I presume you want hours and fractions of an hour, e.g. 8.25 hours? If
so calculate the time difference in minutes using the DateDiff
function and divide by 60:

=DateDiff("n", [logintime], [logofftime]) / 60
 
Back
Top