.0 is creating #VALUE! Error
I am currently using the following formula:
=(H21*60)-IF(MID(H21,FIND(".",H21,1),5)0,(MID(H21,FIND(".", H21,1),5)*60),"")+(MID(H21,FIND(".",H21,1),5))
However, I get the results of #VALUE!
In cell H21, the value is 27.00
How do I force excel to recognize the .00 in the formula?
Thanks,
Ryan
|