MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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