Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Overtime hours in a spreadsheet
Hello-
I was wondering if there is a formula to automatically calculate time and a half for any hours over forty?... I got total hours in one cell (f38) and below that I got a formula for the total hours times 10 (=F38*10)... but what formula should I use to calculate time and a half for anything over 40 hours?... everything under 40 obviously at 10 dollars an hour and anything over forty at 15 dollars an hour... I know you smart, intelligent people got the answer lol :0).... thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Compute Overtime hours | Excel Worksheet Functions | |||
overtime hours formula | Excel Worksheet Functions | |||
if then formula for total time ;overtime hours versus regular | Excel Worksheet Functions | |||
Overtime Hours | Excel Worksheet Functions | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions |