To calculate time difference in hours either

=B1-A1+(A1B1)

or

=MOD(B1-A1,1)

if you want the hours in decimal format multiply by 24, e.g.

=MOD(B1-A1,1)*24


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