Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel: How do I setup a function to put any numbers over 80 into .
I am trying to setup a payroll spreadsheet for a 2 week period. I would like
once my total for an employee exceeds 80 hours to put the additional hours over 80 into a seperate overtime pay cell. Any suggestions? |
#2
|
|||
|
|||
Hi!
Try something along these lines: For straight time: =MIN(SUM(Time_Range),80) For OT (over 80): =MAX(0,SUM(Time_Range)-80) Biff -----Original Message----- I am trying to setup a payroll spreadsheet for a 2 week period. I would like once my total for an employee exceeds 80 hours to put the additional hours over 80 into a seperate overtime pay cell. Any suggestions? . |
#3
|
|||
|
|||
Nick,
From my understanding, you need to columns. One for total hours under or equal to 80 and one for total hours over 80. In the <=80 cell use this formula =IF(SUM(MyRange)80,80,SUM(MyRange)) and in the 80 cell use =IF(SUM(MyRange)80,SUM(MyRange)-80,0) Replace MyRange with the cells you add to get total hours Cheers! "Nick Pettiet" wrote: I am trying to setup a payroll spreadsheet for a 2 week period. I would like once my total for an employee exceeds 80 hours to put the additional hours over 80 into a seperate overtime pay cell. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
Excel Send To function problem | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |