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