View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default regular and overtime hours

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
like roll A4 to G4 over time to beable to calculate from either roll A2 to G2
or A3 to G3.