re: schedule
Posted by Dale on March 01, 2001 9:50 AM
David, the formula worked great. now I have one other small question. If I enter the word "off" into each cell, how can I get the result of that sme formula to show zero instead of #value! thanks again for the help
Posted by Dale on March 01, 2001 10:05 AM
=IF((F3-E3)*24>6,(F3-E3)*24-1,(F3-E3)*24)
Posted by Aladin Akyurek on March 01, 2001 10:21 AM
To assist Dave and/or Mark:
=IF(AND(ISNUMBER(E3),ISNUMBER(F3)),Dave's Or Mark's Formula,0)
Dale: I mean no offense, but why didn't you continue the original thread you started? I think Dave or Mark wouldn't have missed your new question. Again no offense intended.
Aladin
Posted by Dale on March 01, 2001 11:55 AM
aladin
Posted by DALE on March 01, 2001 11:57 AM
Re: aladin
SORRY I'M NEW AT THIS AND I JUST LEARN BY TRIAL AND ERROR
Posted by David Hawley on March 01, 2001 4:17 PM
For Dale!
Hi Dale
Sometimes you are better off posting a new question like you have, so that others will help.
You could use Aladins addition or enter an Array formula:
=IF(ISNUMBER(A1:B1),IF((B1-A1)*24>6,(B1-A1)*24-1,(A1-B1)*24),"")
Arrays must be entered by push Ctrl+Shift+Enter
Dave
OzGrid Business Applications
