#Value is appearing, why?

[wkirkcrawford]

Greetings,

This is my formula, =IF(T8<>"",IF(U8=0,"",MOD(R8-I8,1)),"")

This has worked in the past, but why not now?

W Kirk Crawford
Tularosa, New Mexico

 

[JoeMo]

One or more of your cells U8,R8,I8 has text not number(s).

 

[wkirkcrawford]

Joe,

Well, one cell is a number, and the others are time.
Maybe I need to check the cell that has time in it is ""?
Thanks Joe.

W. Kirk Crawford
Tularosa, New Mexico

 

[wkirkcrawford]

Joe,

Believe it or not, I refreshed it and it worked.

I'm getting odd errors with this version, 2013 on my Surface RT.

Thanks
W. Kirk Crawford
Tularosa, New Mexico