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?