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

--
Regards

Roger Govier


"Curtis" wrote in message
...
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?