Just do the difference of the dates.
But make sure the resulting cell has the custom format "[hh]:mm"
--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
View this thread:
http://www.excelforum.com/showthread...hreadid=277245