| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Threaded Mode
