LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
rob
 
Posts: n/a
Default Excel won't allow times to be negative

I keep track of times in "mm:ss.00" format, and i've set up a formula that
deducts week B's time from week A's time - in order to show improvement. If
the time decreases week to week excel outputs a positive to represent this. I
would like it to ouput a negative number to represent increases in time.

Problem is, excel won't allow times to be negative - if they are it fills
the cell with "#" symbols.

Does anyone have any solutions to this.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do i get excel to add a range of times & display as total as . pm_faery Excel Discussion (Misc queries) 2 May 10th 05 05:51 PM
Negative times gavin Excel Discussion (Misc queries) 8 March 27th 05 02:41 PM
display negative values as a blank cell in Excel pherozeb Excel Discussion (Misc queries) 3 January 5th 05 04:40 AM
display negative values as a blank cell in Excel Pheroze Bharucha Excel Discussion (Misc queries) 0 January 4th 05 10:51 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"