ExcelBanter - display time variance in negative numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - display time variance in negative numbers (https://www.excelbanter.com/excel-discussion-misc-queries/224898-display-time-variance-negative-numbers.html)

seadog471

display time variance in negative numbers

How do you display a time variance in negative numbers?

Bernard Liengme[_3_]

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?

RagDyeR

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?

seadog471

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?

All times are GMT +1. The time now is 10:15 AM.