| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Biweekly SS with Weekly Overtime totals
I have just started payrolls on a bi-weekly schedule. How do I get my formula
to figure the hours as weekly 40 plus overtime rather than 80 and over is overtime if they work 32 hrs one week and 45 the next it should have 5 hrs overtime....Its probably an easy formula but I am drawing a blank....Any help will be much appreciated!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Biweekly SS with Weekly Overtime totals
If Week1 hrs are in cell A1 and week 2 in Cell B1
Overtime for the 2 weeks is =max(0,A1-40)+max(0,B1-40) "D4Taz" wrote: I have just started payrolls on a bi-weekly schedule. How do I get my formula to figure the hours as weekly 40 plus overtime rather than 80 and over is overtime if they work 32 hrs one week and 45 the next it should have 5 hrs overtime....Its probably an easy formula but I am drawing a blank....Any help will be much appreciated!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Biweekly SS with Weekly Overtime totals
Thanks so much!! That was what I was looking for!! :)
N Harkawat wrote: If Week1 hrs are in cell A1 and week 2 in Cell B1 Overtime for the 2 weeks is =max(0,A1-40)+max(0,B1-40) I have just started payrolls on a bi-weekly schedule. How do I get my formula to figure the hours as weekly 40 plus overtime rather than 80 and over is overtime if they work 32 hrs one week and 45 the next it should have 5 hrs overtime....Its probably an easy formula but I am drawing a blank....Any help will be much appreciated!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a timesheet to add daily and weekly hours and overtime | Excel Worksheet Functions | |||
| Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
| How can I calculate weekly totals of daily data in Excel | Excel Worksheet Functions | |||
| how do I write a formula that will figure weekly overtime? | Excel Worksheet Functions | |||
| timesheet with running totals of overtime | Excel Worksheet Functions | |||
Linear Mode
