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?

Try with date from 1904 in tools / option / compute



"alexfthe" a écrit dans le message de news:
...
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?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521327

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)

"alexfthe" wrote in message
...
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?