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



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

[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)

"alexfthe" <[email protected]> wrote in message
news:[email protected]...
> 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?