Calculate total hours based on Time
I have a created a “Daily Attendance Record” called tblsDAR. Within the table I have created the fields:
DaysoftheWeek(DOW), i.e, Mon, Tues, etc…
Time1: In 99:00\ >LL;0;_
Time2: Out 99:00\ >LL;0;_
My issue is this, When a client record is entered, I am able to enter the TimeIN and TimeOut. Such as in increments of the ¼ hour, ½ hour or a full hour. For example I enter the record for:
Clientname: Bob Jones
DOW: Monday 03/22/2006
Time1: Time In 8:45am
Time2: Time Out 1:00pm
This is done for the week. I want Access to “calculate” the Total Units of Service for the week or to return the sum value based on the TimeIN/TimeOut field(s).
Any help is definitely appreciated.