Hi..

You may have to convert the time entered as Decimal for clarity in
results..

A1 10:15
B1 10:45

in C1 & D1.. u may have to apply following formula

in C1 (A1 * 24)*60
in D1 (B1 * 24)*60

then,
in E1.. u may enter D1-C1

..this may not match ur expectations..but it may help..if not..ignore


--
excel_googler
------------------------------------------------------------------------
excel_googler's Profile: http://www.excelforum.com/member.php...o&userid=16610
View this thread: http://www.excelforum.com/showthread...hreadid=314719