formula result different form manual imput

[alexandruc]

Hello,

I have the following formula:
=IF(OR(C5="B";C5="M";C5="Î";C5="N";C5="CO";C5="D");TEXT("-";IF((D5-C5)>I2;(D5-C5-$I$2);"-"))

The problem is in this part:IF((D5-C5)>I2;(D5-C5-$I$2);"-")

If in I2 cell I manualy type: "08:30:00" everyting is fine and the formula works.
But if I get 08:30:00 from this formula:
=IF(WEEKDAY(C2;2)=5; "06:00:00"; "08:30:00")
The first formula is evaluated as fase.

I cannot understand where i made the mistake.

Attached is an example of the problem. In I2 cell the formula is not working for the F5 cell, but if you will remove the I2 formula and type the same by hand, F5 formula will work.

[NBVC]

Try changing this formula:

=IF(WEEKDAY(C2;2)=5; "06:00:00"; "08:30:00")

to

=IF(WEEKDAY(C2;2)=5; "06:00:00"+0; "08:30:00"+0)

and format as time, if required.

The +0 coerces the text string as a number...

[alexandruc]

Thanks a lot. That did it!

[NBVC]

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save