Calculate Time

[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

 

[John Vinson]

How can I make it perform the calculation ?
That is, add up the total time in hour format ?

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