How do i display negative time differently?
 

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(B3N3,(SUM(B3-N3)),"("SUM(N3-B3)")") and that didn't work either

Appriciate any help at all
Nick

How do i display negative time differently?
 

"Nick Berning" <Nick wrote in message
...
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(B3N3,(SUM(B3-N3)),"("SUM(N3-B3)")") and that didn't work either

Tools/ Options/ Calculation:
select 1904 date system.
--
David Biddulph