How will excel know if time is already an overtime. Please see example below:
TIME IN TIME OUT REG HRS WORKED OT HRS WORKED
8:00 9:00 1:00 0:00
9:00 9:50 0:50 0:00
9:50 12:00 2:10 0:00
1:00 4:30 3:30 0:00
4:30 6:30 0:30 1:30
Hope you could help me.
Thanks