| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
negative dates or times are displayed as # # # #
I have two cells that carry two different times as follow
cell A1 has 00:05:00 cell A2 has 00:04:00 cell A3 should display the difference in negative way(-00:01:00). I only get ##### instead of the answer in cell A3 and a message reads (negative dates or times are displayed as # # # #) Your help will be much appricated. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| Negative Times Displayed as # # # # | Excel Discussion (Misc queries) | |||
| Dispalying negative times | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
Threaded Mode
