How do i display negative time differently?

[Guest]

I'm working on a calculation sheet for a X-country team. I want to try to
figure out how to display differently if they ran a faster time. But i can't
get excel to display negative time and i've tried
=IF(B3>N3,(SUM(B3-N3)),"("SUM(N3-B3)")") and that didn't work either

Appriciate any help at all
Nick

 

[David Biddulph]

I'm working on a calculation sheet for a X-country team. I want to try to
figure out how to display differently if they ran a faster time. But i
can't
get excel to display negative time and i've tried
=IF(B3>N3,(SUM(B3-N3)),"("SUM(N3-B3)")") and that didn't work either

Tools/ Options/ Calculation:
select 1904 date system.