Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with a payroll formula
I'am just learning to use formulas and working on a payroll spreadsheet. I
have it all done except that overtime is paid after 40 hours. I need a formula that tells it to take any hours over 40 and put it into the overtime column. Can you help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with a payroll formula
say hours worked are in cell a1 then to have overtime in cell b1 type the
following: =max(0,a1-40) "Frustrated" wrote in message ... I'am just learning to use formulas and working on a payroll spreadsheet. I have it all done except that overtime is paid after 40 hours. I need a formula that tells it to take any hours over 40 and put it into the overtime column. Can you help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
How do I setup a formula for payroll deductions in excel | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |