I have a spreadsheet with columns with time in and out, and rows for time clock times and paid times:
PAYROLL MONDAY TUESDAY
IN OUT IN OUT
CLOCK TIME 1-Aug 7:58 AM 5:15 PM 8:03 AM 5:00 PM
TIMESHEET 8:00 AM 5:15 PM 8:00 AM 5:00 PM
CLOCK TIME 15-Aug 7:57 AM 4:59 PM 7:59 AM 4:58 PM
TIMESHEET 8:00 AM 5:00 PM 8:00 AM 5:00 PM
I need to be able to calculate total minutes late for each pay period of ten days (columns) and total minutes employees left early for each pay period (also ten columns). If I can figure out how to obtain the information for one pay period, then I can solve the rest easily. I need only calculate minutes later than 8:00 am, and minutes earlier than 5:00 pm.
Any assistance you can provide me as soon as possible is tremendously appreciated.
Bookmarks