| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| overtime hours formula | Excel Worksheet Functions | |||
| regular and overtime hours | Excel Worksheet Functions | |||
| Work out overtime hours for individuals | New Users to Excel | |||
| Work out overtime hours for individuals | New Users to Excel | |||
| Overtime Hours | Excel Worksheet Functions | |||
Hybrid Mode
