Hello crispbd from Steved

Is it possible please to make your formula more robust
ie 9.00 - 7.00
If I put in 9.05 - 7.05 returns 120 but type in 9.00 -
7.00 it returns #value!

Thankyou.

-----Original Message-----

In Cell A1: 8.35
In Cell B1: 7.45

=(VALUE(LEFT(A1,LEN(A1)-3)) * 60 + VALUE(RIGHT(A1,2))) -
(VALUE(LEFT(B1,LEN(B1)-3)) * 60 + VALUE(RIGHT(B1,2)))


--
crispbd
----------------------------------------------------------
--------------
crispbd's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=10880
View this thread:
http://www.excelforum.com/showthread...hreadid=320247

.