=B1+24-A1

A1=Start time
B1=End time

Note: Only works within 24 hour time period.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=499249