Say start time is in A1 and End time in B1 then enter the below formula
into C2 and format as [h]:mm
=IF(A1B1,B1+1-A1,B1-A1)
VBA Noob
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=567218