T Terry Nov 15, 2009 #1 need to find the formula for b3 is 8 hrs c3 = -.50min / b3 is less than 8hrs c3 -.25 example b3 8. hrs c3 7.5 hrs / b3 6. hrs c3 5.75
need to find the formula for b3 is 8 hrs c3 = -.50min / b3 is less than 8hrs c3 -.25 example b3 8. hrs c3 7.5 hrs / b3 6. hrs c3 5.75
B Bernard Liengme Nov 15, 2009 #2 Terry: take a big breath and retype this slowly using punctuation and line feeds. We do want to help but this makes no sense to me Unlike cell phone text messages, there is no word-count cost. best wishes
Terry: take a big breath and retype this slowly using punctuation and line feeds. We do want to help but this makes no sense to me Unlike cell phone text messages, there is no word-count cost. best wishes
P Pete_UK Nov 15, 2009 #3 I agree with Bernard, but I think what you need is this in C3: =B3-IF(B3<8,0.25,0.5) Hope this helps. Pete
I agree with Bernard, but I think what you need is this in C3: =B3-IF(B3<8,0.25,0.5) Hope this helps. Pete
