Work hours with overtime
 

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?

Work hours with overtime
 

and how do we recognise overtime hours?

"Debby_Jo" wrote:

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?

Work hours with overtime
 

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

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


Gord Dibben MS Excel MVP

On Wed, 30 Jul 2008 11:36:00 -0700, Debby_Jo
wrote:

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?