need a formula
 

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 a formula
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Terry" wrote in message
...
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 a formula
 

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

On Nov 15, 7:04*pm, Terry wrote:
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