presuming you enter 1:15 as 1:15 pm, simply subtract the first from the
second and format as time. If you want the result as an integer 17,
then multiply the above result with 1440 which is nothing but 24*60

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379586