Over time hours

C

Curtis

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

Curtis

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

Mike

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
 
R

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
 
C

Curtis

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.
 

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