View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chris Bode[_17_] Chris Bode[_17_] is offline
external usenet poster
 
Posts: 1
Default Negative time displaying as #####


Set the format of the cell showing the subtraction result as
..suppose the result is in C1..select c1 and enter formula
=TEXT(A1,"mm:ss")....

hope it helps

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode