because excel doesn't know you mean 7:56 the next day you are
effectively asking it to show a negative time.
Therefore you have two options
firstly enter both a date and time
or use an "if" formula

=if(B1A1,B1-A1,1+B1-A1)

The 1 efectively adds 24hrs onto the time

hope this is what you need

RES


--
RES
------------------------------------------------------------------------
RES's Profile: http://www.excelforum.com/member.php...o&userid=19307
View this thread: http://www.excelforum.com/showthread...hreadid=345844