Overtime

C

Curtis

How do I calculate using a 8 hour and 40 hour overtime formula? What I am
working on is I have three roll of days off with pay, regular hours and
overtime. We use 40 hour overtime formula for regular hour overtime, but have
to use 8 hour over for days off. Example:
A B C D E F G H I
1 Hour Type Mon Tues Wed Thur Fri Sat Sun Total
2 Days off 0 0 15 10 0 0 10 35
3 Regular 15 15 0 0 18 16 0 64
4 Overtime ? ? ? ? ? ? ?

We have to use 8 hour overtime rules when they work on their days off with
pay any thing over 8 hour is over time. On regular hours any over 40 hours
for week period is overtime. How to use formula for 40 and 8 hour for
overtime?
 
R

Roger Govier

Hi Curtis

If I understand your question correctly, in B4 enter
=IF(B2>0,MAX(0,(B2-8)),0)
The total overtime would be
=SUM(B4:H4)+I4+MAX(0,I3-40)
which by pure coincidence works out at 35 hours - the same as hours
worked on Days off.
 

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