Over time hours

[Guest]

Need help on solving a problem, I have A1 to G1 as (Sun thru Sat) for Days
off with pay, A2 to G2 where I put hours; then A3 to G3 is for regular hours;
then A4 to G4 is overtime hours, I have the regular hours ( A3 to G3 ) set up
perfect to work with overtime hours ( A4 to G4), Question is how do you get
overtime hours from A2 to G2 to work in A4 to G4 too if not using A3 to G3? I
want A4:G4 over time to beable to calculate from either A2:G2
or A3:G3.
A B C D E F G
Date 1 Sun Mon Tues Wed Thurs Fri Sat
Days Off 2 0 12 8 18 0 0 0
Regular 3 0 0 0 0 15 17 12
Overtime 4 This roll for overtime
How do you do formulas for both A2:G2 and A3:G3 for overtime in A4:F4?

 

[Guest]

=IF(RegHours>40,RegHours-40,0)

 

[Guest]

This is not the answer I am looking for. I have all ready have it set up for
regular hours for over time, I need to also used days off with overtime too?

 

[Guest]

Im not getting your point on Days off
Are they actual days or are they Hours off
I can help if I have better and more info

 

[Roger Govier]

Hi Curtis

I'm not sure I understand your request but maybe in A4 you need
=if(A2+A3=0,0,MAX(0,MAX(A2,A3)-8))
and copy across

 

[Guest]

Okay, we have a 14 on and 7 off with pay. Most time guys have to work on
their days off so we try to keep hours separate from regular hours. What I am
trying to do if they work overtime on their days off I want the over time to
be in same line as the regular hour over time too. Days off with pay is
A2:G2; regular hour is A3:G3; over time is A4:G4. Now if theres overtime in
A2 if not A3 then its A4 or if there overtime in A3 if not A2 then its A4.