display time variance in negative numbers

  • Thread starter Thread starter seadog471
  • Start date Start date
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.
 
RagDyer said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate variance percetage if figures are negative 5
Variance Calculations 2
Power Pivot Variance Column 0
Pivot table and variance calculation 1
Color a calculated percentage cell text red if results negative 1
Obtaining a positive variance % 3
EXCEL FORMULA 2
Variance between two cells only if... 5

Back
Top