G
Guest
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?
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?