Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate overtime hours in Excel using formulas?
I need information on how to enter the proper syntax (formula) so that excel
can calculate overtime hours. In california over 8 hrs in one day is overtime. The 8 would be considered regular hours and anything over is OT. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate overtime hours in Excel using formulas?
http://www.cpearson.com/excel/overtime.htm
-- Kind regards, Niek Otten "Toeknee" wrote in message ... I need information on how to enter the proper syntax (formula) so that excel can calculate overtime hours. In california over 8 hrs in one day is overtime. The 8 would be considered regular hours and anything over is OT. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate overtime hours in Excel using formulas?
If the hours worked in a given day are in cell B2, the overtime hours are
calculated by =max(0,b2-8). Basically, just subtract 8 (the regular hours). The max ensures that you don't post negative OT hours if the total hours is less than 8. --Bruce "Toeknee" wrote: I need information on how to enter the proper syntax (formula) so that excel can calculate overtime hours. In california over 8 hrs in one day is overtime. The 8 would be considered regular hours and anything over is OT. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time sheets | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions |