| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Over time.
I am looking for a payroll formula, something like this
days hours M 8 T 8 W 8 T 8.5 F 8.5 ------------- Reg 40 OT 1 ------------ total 41 ---------- I want the Reg hour Formula to have anything that is 40hours or less than forty. i want the over time cell to have anything over forty and i would want to have a formular adding the reg and and overtime. something like Regular =40 or less than 40. Overtime = more than 40. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Over time.
Hi,
Regulaer hours =MIN(40,SUM(B1:B5)) overtime hours =MAX(0,SUM(B1:B5)-40) Mike "Swanie" wrote: I am looking for a payroll formula, something like this days hours M 8 T 8 W 8 T 8.5 F 8.5 ------------- Reg 40 OT 1 ------------ total 41 ---------- I want the Reg hour Formula to have anything that is 40hours or less than forty. i want the over time cell to have anything over forty and i would want to have a formular adding the reg and and overtime. something like Regular =40 or less than 40. Overtime = more than 40. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Over time.
Thanks Mike H. It works!!!
"Mike H" wrote: Hi, Regulaer hours =MIN(40,SUM(B1:B5)) overtime hours =MAX(0,SUM(B1:B5)-40) Mike "Swanie" wrote: I am looking for a payroll formula, something like this days hours M 8 T 8 W 8 T 8.5 F 8.5 ------------- Reg 40 OT 1 ------------ total 41 ---------- I want the Reg hour Formula to have anything that is 40hours or less than forty. i want the over time cell to have anything over forty and i would want to have a formular adding the reg and and overtime. something like Regular =40 or less than 40. Overtime = more than 40. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
