Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overtime for 8 hour and 40 hour
Need help on how to do calculate formula when using 8 hour and 40 hour
overtime rule. What I am doing is try to build spreadsheet for tracking of working hours on regular hour, days off with pay and overtime, below is example of what it looks like: A B C D E F G H I 1 Hour Type MON Tues Wed Thur Fri Sat Sun Total 2 DayOff 0 0 8 15 14 0 0 37 3 Regular 14 15 0 0 0 17 12 58 4 Overtime ? ? ? ? ? ? ? 0 On days off employee gets time off with pay, if employee works on that day off and works over 8 hours it falls into 8 hour rule overtime for each day. If he works on regular work days he has to work 40 hours before start getting the overtime. I have to use both 40 and 8 hour overtime, question is how do you use formula to work with both 40 and 8 hour in roll 4 for overtime? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overtime for 8 hour and 40 hour
In your example, would employee get 18 hours "Regular Overtime" (58-40) PLUS
13 hours "Day off" overtime [ (15-8 )+(14-8)]? "Curtis" wrote in message ... Need help on how to do calculate formula when using 8 hour and 40 hour overtime rule. What I am doing is try to build spreadsheet for tracking of working hours on regular hour, days off with pay and overtime, below is example of what it looks like: A B C D E F G H I 1 Hour Type MON Tues Wed Thur Fri Sat Sun Total 2 DayOff 0 0 8 15 14 0 0 37 3 Regular 14 15 0 0 0 17 12 58 4 Overtime ? ? ? ? ? ? ? 0 On days off employee gets time off with pay, if employee works on that day off and works over 8 hours it falls into 8 hour rule overtime for each day. If he works on regular work days he has to work 40 hours before start getting the overtime. I have to use both 40 and 8 hour overtime, question is how do you use formula to work with both 40 and 8 hour in roll 4 for overtime? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help w/ formula for taking lunch & overtime out of a 9 hour | Excel Discussion (Misc queries) | |||
Tracking overtime signups in 1/2 hour increments by day | Excel Discussion (Misc queries) | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions |