Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|