Overtime for 8 hour and 40 hour


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?
 
Ad

Advertisements

T

toppers

In your example, would employee get 18 hours "Regular Overtime" (58-40) PLUS
13 hours "Day off" overtime [ (15-8 )+(14-8)]?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top