formulas
 

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

formulas
 

Check out this page Mark
http://www.cpearson.com/excel/overtime.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"mark" wrote in message ...
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