PPRuNe Forums - View Single Post - Some Excel help
Thread: Some Excel help
View Single Post
Old 7th December 2009 | 10:20
  #2 (permalink)  
bnt
15 Anniversary
 
Joined: Feb 2007
Posts: 755
Likes: 26
From: Dublin, Ireland. (No, I just live here.)
I wouldn't try to do it all in one formula; rather, I'd split the problem in to multiple cells. My way involves using formulas to split off the overtime hours. Rather than try to explain it, I threw an example together, here. (The IF formulas in C2 and D2 are because you don't want negative hours popping up.)
bnt is offline  
Reply