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

.