Work hours with overtime

[Debby_Jo]

I need a formula that will calculate daily hours worked. If the hours are
more than 5 the formula also needs to subtract thirty minutes for lunch from
the daily total hours. Then the formula needs to multiply the daily total
hours by hourly rate ($10.71) for regular hours as well as overtime hours
($16.07). Can anyone help with this one?

 

[Mike H]

and how do we recognise overtime hours?

 

[Gord Dibben]

See Chip Pearson's site for timesheets, lunch breaks and OT.

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


Gord Dibben MS Excel MVP