Negative Time

[gary_bray]

Hi,

Wonder if you can help:

BookedDate	Time	ArrivalDate	Time	DepTime	Diff
03/07/12	07:30:00	03/07/12	07:23:00	08:00:00	########

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

I want to show the time diff as -00:07:00, as the vehicle has arrived before the booked time. If I use 1904 date system it works but changes the dates in the date column?? Can it be done another way??

Kind regards,

Gary.

 

[martindwilson]

=TEXT(ABS(d1-b1),"-h:mm:ss") will give the answer but cannot be used in any further calulation​