LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Negative times are displayed a ###########

Dear Experts,
How can I get the real figure if I have the following message?
Negative times are displayed a ###########.
Actually I got the above massage from the below formula.
=2:49 - 3:17, (hh:mm format)
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
Zero displayed in place of negative values TC Excel Discussion (Misc queries) 3 May 9th 07 08:07 PM
negative dates or times are displayed as # # # # Amr Shehata Excel Worksheet Functions 4 February 2nd 07 11:35 AM
negative dates or times are displayed as # # # # Amr Shehata New Users to Excel 3 November 9th 06 12:34 PM
Negative Times Displayed as # # # # AntnyMI Excel Discussion (Misc queries) 1 September 21st 06 04:43 PM
Whats the function to count the total times a word is displayed Monk Excel Discussion (Misc queries) 3 December 10th 04 10:39 PM


All times are GMT +1. The time now is 06:16 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"