PPRuNe Forums - View Single Post - Some Excel help
Thread: Some Excel help
View Single Post
Old 7th Dec 2009, 10:20
  #2 (permalink)  
bnt
 
Join Date: Feb 2007
Location: Dublin, Ireland. (No, I just live here.)
Posts: 733
Received 8 Likes on 7 Posts
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 online now