M
mark
I am trying to write a formula which will add up working
hours and then seperate this into regular and overtime
form the clock in and clock out times.
EI; clock in clock out regular hours overtime hours total
22:00 08:15 8 2.25 10
working day is based on an 8 hour shift.
can anyone help.
Mark
hours and then seperate this into regular and overtime
form the clock in and clock out times.
EI; clock in clock out regular hours overtime hours total
22:00 08:15 8 2.25 10
working day is based on an 8 hour shift.
can anyone help.
Mark