Negative Time

[alexfthe]

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?

 

[Dominique Ancion]

Try with date from 1904 in tools / option / compute

 

[daddylonglegs]

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?

 

[Bob Phillips]

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)