Excell rejects my formula, how do I fix this one?

[sonar]

Hi, I have a problem making this formula work, I cant find the problem
and excell keeps promting me to fix a problem, can anyone help?


=IF((CD17)<>"",0,

(if(CB17>(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0))))),0


(IF(OR(BW17=0,BX17=0),0,IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))-CB17)

)

regards
Sona

 

[JulieD]

Hi sonar

try
=IF((CD17)<>"",0,(IF(CB17>(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(
7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))),0,(IF(OR(BW17=
0,BX17=0),0,IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),B
X17-TIME(19,0,0),0)))-CB17)))

this takes one bracked out from the end of(if(CB17>(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(
IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0))))),0,


and adds it to

)

let us know how you go

Cheers
julieD

 

[sonar]

thanks for helping with this one, much appreciated.

regards
Sonar

 

[JulieD]

you're welcome

 

[sonar]

Hi

I need your help again.

With this formula that we fixed, when the amount displayed in my CB1
is the same value displayed in my formula for CC17:

(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))),0,(IF(OR(BW17=0,BX17=0


which calculats my night hours. It freeks out


How can I instead of using the > sign as in my formula

=IF((CD17)<>"",0,(IF(CB17
(IF(OR(BW17=0,BX17=0),0,(IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))),0,(IF(OR(BW17=0,BX17=0),0,IF(BW17<TIME(7,0,0),TIME(7,0,0)-BW17,0))+(IF(BX17>TIME(19,0,0),BX17-TIME(19,0,0),0)))-CB17)))

to an > and equal to CB18 to give me " "