View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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?