View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nick Berning Nick Berning is offline
external usenet poster
 
Posts: 1
Default 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