| 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
negative dates or times are displayed as # # # #
That's what Excel does; it cannot work with negative time/dates
You could try =ABS(A2-A1) and have a flag in an adjacent cell =IF(A2<A1,"Neg","Pos") best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Amr Shehata" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
negative dates or times are displayed as # # # #
This is normal.
Excel doesn't like negative dates and times. For a workaround see John Walkenbach's site. http://www.j-walk.com/ss/excel/usertips/tip051.htm Gord Dibben MS Excel MVP On Wed, 8 Nov 2006 09:35:02 -0800, Amr Shehata wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
negative dates or times are displayed as # # # #
Thak you Bernard. Your idea has done the trick. Thaks for your help.
Amr "Amr Shehata" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
