Crystal Reports Time formula

[michelin]

I'm using Crystal Reports v12.

I have following data:

Unit A Arrived Unit B Arrived Difference
08:29:14 08:29:27 00:00:13
14:11:44 14:11:32 23:59:48

Is there a way how not to get 23:59:48 but of example -00:00:12?

Thanks!

 

[Madawc]

I assume you are using DateDiff. So have a formula, subtract A from B normally, but subtract B from A when it is earlier, and show the result as negative.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP