How do i display negative time differently?

N

Nick Berning

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
 
D

David Biddulph

Nick Berning said:
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
Click to expand...

Tools/ Options/ Calculation:
select 1904 date system.
 
Top