The simple answer is

=B1-A1

format as h:mm

If you may have time periods that start before midnight and end after,
e.g. 21:00 to 06:00 then you could use

=B1-A1+(A1B1)

again format as h:mm


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512881