| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Display Negative Dates
Hello !
Thanks to all you for helping out me in my previous problem. This i have a problem with diplaying negative times, Say A1= 10:30 (format is hh:mm) and B1 = 8:30 (format is hh:mm). when C1=B1-A1, the value is displayed as ##### with notification negative dates and times are displayed as ######. Is there a way to display the negative time (for e.g. 8:30 - 10:30 = -2:00) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to display date correctly######dates and times are negative | Excel Discussion (Misc queries) | |||
| How to display negative $ amount?? | Excel Discussion (Misc queries) | |||
| display negative number as zero | Excel Discussion (Misc queries) | |||
| display negative numbers as zero | Excel Discussion (Misc queries) | |||
| How to display the negative bar in bar chart? | Charts and Charting in Excel | |||
Threaded Mode
