Hello,
I wonder if I could once again ask for advice. I'm looking for a formula to calculate hours worked per shift based on IN / OUT time. My REGULAR SHIFT runs from 7:00 a.m. to 3:30 p.m. - all other hours are grouped into the OVERTIME column.
EXAMPLES:
A B C D E F
Time In Time Out Reg hrs OT Hrs Reg $ OT $
7:00 AM 11:00 AM 3 0 $30.00 $0.00
12:00 PM 6:30 PM 3.5 3 $35.00 $45.00
11:00 PM 3:15 AM 0 4.25 $0.00 $63.75
thank you for your help.
I wonder if I could once again ask for advice. I'm looking for a formula to calculate hours worked per shift based on IN / OUT time. My REGULAR SHIFT runs from 7:00 a.m. to 3:30 p.m. - all other hours are grouped into the OVERTIME column.
EXAMPLES:
A B C D E F
Time In Time Out Reg hrs OT Hrs Reg $ OT $
7:00 AM 11:00 AM 3 0 $30.00 $0.00
12:00 PM 6:30 PM 3.5 3 $35.00 $45.00
11:00 PM 3:15 AM 0 4.25 $0.00 $63.75
thank you for your help.