If you want the result as time then you shouldn't multiply by 24, that
gives you the time in decimal format. An easier formula to do what you
want

=F36-F35+(F35F36)

format as h:mm

note: your cell references are a bit mixed in your post, I'm assuming
start time in F35, end time in F36


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