Formula Diascrepancy in Worksheet

[watermt]

I have the formula below working in two areas of my worksheet but not in the
other. I get the infamous ########## sign return. Can someone help me out
with this?

Cell D111 Cell F111
1/24/2010 12:15:00 AM 1/25/2010 1:30:00 AM

=IF(OR(D111="",F111=""),0,(NETWORKDAYS(D111,F111)-1)*("15:00"-"06:30")+MOD(F111,1)-MOD(D111,1))

Cell N111
Answer: 01:15

******************

Cell D139 Cell F139
11/12/2009 12:22:00 PM 11/12/2009 12:36:00 PM

=IF(OR(D139="",F139=""),0,(NETWORKDAYS(D139,F139)-1)*("15:00"-"06:30")+MOD(F139,1)-MOD(D139,1))

Cell N139
Answer: 00:14
*********************


Cell D153 Cell F153
1/9/2010 3:10:00 AM 1/9/2010 4:00:00 AM

=IF(OR(D153="",F153=""),0,(NETWORKDAYS(D153,F153)-1)*("15:00"-"06:30")+MOD(F153,1)-MOD(D153,1))

Cell N153
Answer: #############

 

[John_McGhie_[MVP]]

The hashes simply mean the destination cell is too narrow to contain the
result. Make the column wider

Cheers

I have the formula below working in two areas of my worksheet but not in the
other. I get the infamous ########## sign return. Can someone help me out
with this?

Cell D111 Cell F111
1/24/2010 12:15:00 AM 1/25/2010 1:30:00 AM

=IF(OR(D111="",F111=""),0,(NETWORKDAYS(D111,F111)-1)*("15:00"-"06:30")+MOD(F11
1,1)-MOD(D111,1))

Cell N111
Answer: 01:15

******************

Cell D139 Cell F139
11/12/2009 12:22:00 PM 11/12/2009 12:36:00 PM

=IF(OR(D139="",F139=""),0,(NETWORKDAYS(D139,F139)-1)*("15:00"-"06:30")+MOD(F13
9,1)-MOD(D139,1))

Cell N139
Answer: 00:14
*********************


Cell D153 Cell F153
1/9/2010 3:10:00 AM 1/9/2010 4:00:00 AM

=IF(OR(D153="",F153=""),0,(NETWORKDAYS(D153,F153)-1)*("15:00"-"06:30")+MOD(F15
3,1)-MOD(D153,1))

Cell N153
Answer: #############

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[pjonesCET]

Click on column in which cell is contained go to Format > Choose Column and choose fit to width. will may cell width just large enough to contain information.