| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to calculate overtime hours for employees
I have the employees time for the week add up in P and I need regular time in
Q and overtime in R. something like hours reg ot 54 40 14 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to calculate overtime hours for employees
Chef --
I'm not sure what the rest of your worksheet is like, but this might work: P Q R 1 54 =MIN(P1,40) =P1-Q1 Hope that helps. "ChefFrank" wrote: I have the employees time for the week add up in P and I need regular time in Q and overtime in R. something like hours reg ot 54 40 14 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to calculate overtime hours for employees
Regular hours: =IF(P140,40,P1)
Overtime: =IF(P140,P1-40,"0") Or if you are listing the hours in column fashion... Regular: =IF(SUM(P:P)40,40,SUM(P:P)) Overtime: =IF(SUM(P:P)40,SUM(P:P)-40,"0") HTH, JP On Nov 16, 6:10 pm, ChefFrank wrote: I have the employees time for the week add up in P and I need regular time in Q and overtime in R. something like hours reg ot 54 40 14 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate overtime hours in Excel using formulas? | Excel Discussion (Misc queries) | |||
| Calculate Hours and overtime by week | Excel Worksheet Functions | |||
| Overtime Hours | Excel Worksheet Functions | |||
| employees hours | Excel Discussion (Misc queries) | |||
| looking for template to track hours on projects for employees | Excel Discussion (Misc queries) | |||
Hybrid Mode
