| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display time variance in negative numbers
How do you display a time variance in negative numbers?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display time variance in negative numbers
Could you expand on what you need?
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "seadog471" wrote in message ... How do you display a time variance in negative numbers? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display time variance in negative numbers
If by time variance you mean, say hours difference between 2 cells:
A1 = 1:30 AM B1 = 4:00 AM =(A1-B1)*24 Where you must format the cell containing the formula to General or Number, in order to get a return of -2.5. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seadog471" wrote in message ... How do you display a time variance in negative numbers? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display time variance in negative numbers
"RagDyer" wrote: If by time variance you mean, say hours difference between 2 cells: A1 = 1:30 AM B1 = 4:00 AM =(A1-B1)*24 Where you must format the cell containing the formula to General or Number, in order to get a return of -2.5. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "seadog471" wrote in message ... How do you display a time variance in negative numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing a column chart for Variance Walk negative numbers | Charts and Charting in Excel | |||
| display negative numbers as zero | Excel Discussion (Misc queries) | |||
| How do i display negative time differently? | Excel Discussion (Misc queries) | |||
| how do i display a variance in all positive numbers? | Excel Worksheet Functions | |||
| How do I display time in a negative format? | Excel Worksheet Functions | |||
Hybrid Mode
