Here is one formula I use to get time duration:

=IF(OR(F2="",G2=""),"",(G2-F2+(G2<F2))*24)

Just change the cell references to your sheet

Ensure you have your cells as numbers or time not text

Rick


--
RudeRam


------------------------------------------------------------------------
RudeRam's Profile: http://www.excelforum.com/member.php...fo&userid=8818
View this thread: http://www.excelforum.com/showthread...hreadid=555600