calculate negative or positve difference in time

I make two manual entries of average times to compare last year with this
year. I need to calculate the difference between the two times (it could be
an increase or decrease), and show both the difference (+ or -) in hours and
minutes, and the % of change (+ or -) from last year to this year.

Example: 2:03 average talk time last year, 3:50 average talk time this year
= increase of 1:47 (1 min. 47 sec.). or 86.99 % increase in talk time.

As a time view

=IF(A1>B1,"-","")&TEXT(ABS(A1-B1),"hh:mm:ss")

percentage

=IF(A1>B1,"-","")&TEXT(ABS(A1-B1)/A1,"0.0%")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kpmoore" <[email protected]> wrote in message
news:[email protected]...
> I make two manual entries of average times to compare last year with this
> year. I need to calculate the difference between the two times (it could
be
> an increase or decrease), and show both the difference (+ or -) in hours
and
> minutes, and the % of change (+ or -) from last year to this year.
>
> Example: 2:03 average talk time last year, 3:50 average talk time this
year
> = increase of 1:47 (1 min. 47 sec.). or 86.99 % increase in talk time.

Bob--

Don't know who you are or where you work, but they're lucky to have you.
Thanks for solving my problem!

Kay


"Bob Phillips" wrote:

> As a time view
>
> =IF(A1>B1,"-","")&TEXT(ABS(A1-B1),"hh:mm:ss")
>
> percentage
>
> =IF(A1>B1,"-","")&TEXT(ABS(A1-B1)/A1,"0.0%")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "kpmoore" <[email protected]> wrote in message
> news:[email protected]...
> > I make two manual entries of average times to compare last year with this
> > year. I need to calculate the difference between the two times (it could
> be
> > an increase or decrease), and show both the difference (+ or -) in hours
> and
> > minutes, and the % of change (+ or -) from last year to this year.
> >
> > Example: 2:03 average talk time last year, 3:50 average talk time this
> year
> > = increase of 1:47 (1 min. 47 sec.). or 86.99 % increase in talk time.
>
>
>