Negative Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking at deviations from an average time (today was 2 minutes faster
than average, yesterday was 3 minutes slower, etc), but excel refuses to
display negative times if i simply enter a formula =Today'sTime-AverageTime.
I know how to get an absolute difference, but i want the signed (+ or -) time
so I can tell fast from slow. Any way to do this?
 
You could convert to minutes to allow negative values, i.e.

=(B1-A1)*1440

custom format as +0;-0;0

although this may be complicated by time periods from one day to the
next, do you have just times or times/dates?
 
Multiply the time by 24 and you will get decimal hours which supports
negatives.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top