Menu

How do i display negative time differently?

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.misc

David Biddulph David Biddulph is offline

David Biddulph is offline

external usenet poster

Posts: 618

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Negative and Positive Time	DazedandConfused	Excel Discussion (Misc queries)	2	September 20th 06 11:34 PM
Time Display ?	Bob Newman	Excel Worksheet Functions	3	February 2nd 06 03:20 AM
Negative Time	BryHam	Excel Discussion (Misc queries)	2	July 14th 05 09:03 AM
Negative Time Values	B. Baumgartner	Excel Discussion (Misc queries)	1	July 1st 05 10:16 AM
how do i display a time value conditionally	stuck!	Excel Discussion (Misc queries)	1	April 8th 05 11:50 PM

All times are GMT +1. The time now is 10:45 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement