Timetables Rotas

[Shibs2012]

Can someone please help me i am trying to find a formula that will calculate someones shift for an example i have someone starting at 9.00 hrs and finishing at 18.00 which should calculate to 8 hrs with an hours lunch can someone please help or advise me on how to do this in excel thank you.

The rules are anyone who works over 8 hours has an unpaid hours lunch

 

[Airfix9]

Are the times entered as times? e.g. 09:00

If so, assuming start is in A1 and end is in B1, formula would be:

=IF(B1-A1>=0.333333333333333,B1-A1-0.0416666666666667,B1-A1)

 

[anglais428]

see http://www.cpearson.com/excel/overtime.htm