Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Startime: 6:00 Endtime: 22:00
up to 8 hours Reg hours = 8 8.1 to 12 hrs 1.5x ot = 4 12.1 to 14 2x ot = 2 14.1 and up 2.5x ot = 4 if they work 6 days straight up to 8 hrs is Reg anything over 8 is 2x ot. If they work on the 7th day it is 2.5x ot. Thanks for your help in advance Chase |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Maybe there is a template for some of what you need
Try: http://office.microsoft.com/en-us/te...172771033.aspx HTH "Chase Michaels" wrote: Startime: 6:00 Endtime: 22:00 up to 8 hours Reg hours = 8 8.1 to 12 hrs 1.5x ot = 4 12.1 to 14 2x ot = 2 14.1 and up 2.5x ot = 4 if they work 6 days straight up to 8 hrs is Reg anything over 8 is 2x ot. If they work on the 7th day it is 2.5x ot. Thanks for your help in advance Chase |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating overtime | Excel Discussion (Misc queries) | |||
Calculating Overtime | Excel Worksheet Functions | |||
Calculating timesheet with overtime | Excel Worksheet Functions | |||
Need help calculating overtime to date | Excel Worksheet Functions | |||
Calculating overtime | New Users to Excel |