sammers101
Registered User.
- Local time
- Yesterday, 21:00
- Joined
- May 11, 2012
- Messages
- 89
Trying to calculate the hours my employees have worked. The table format I'm using can't be altered, its created by our pos program.
For example I have
fldUserID fldTime fldType fldDate
blake 12:04:38 PM Begin Shift 6/3/2018
blake 6:31:44 PM End Shift 6/3/2018
sam 9:22:06 AM Begin Shift 6/4/2018
James 5:03:16 PM Begin Shift 6/4/2018
sam 5:33:59 PM End Shift 6/4/2018
James 8:03:16 PM Lunch Out 6/4/2018
I thought I could do something like timeclock.id=timeclock_1.id+1
but people dont neccessarily clock in and out like that.
For example I have
fldUserID fldTime fldType fldDate
blake 12:04:38 PM Begin Shift 6/3/2018
blake 6:31:44 PM End Shift 6/3/2018
sam 9:22:06 AM Begin Shift 6/4/2018
James 5:03:16 PM Begin Shift 6/4/2018
sam 5:33:59 PM End Shift 6/4/2018
James 8:03:16 PM Lunch Out 6/4/2018
I thought I could do something like timeclock.id=timeclock_1.id+1
but people dont neccessarily clock in and out like that.