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?
|