Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kpmoore
 
Posts: n/a
Default 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.
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

As a time view

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

percentage

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

--

HTH

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


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



  #3   Report Post  
kpmoore
 
Posts: n/a
Default

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(A1B1,"-","")&TEXT(ABS(A1-B1),"hh:mm:ss")

percentage

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

--

HTH

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


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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I replace a negative number at the end of a formula with a. dealn2 Excel Discussion (Misc queries) 5 December 23rd 04 08:47 PM
Calculating time difference Robyn Bellanger Excel Discussion (Misc queries) 2 December 23rd 04 03:29 AM
How do you calculate the difference between two values within a p. emlouise Excel Discussion (Misc queries) 2 December 10th 04 04:13 AM
What is the formula for getting time difference e.g. ("4 hrs 15 m. Sandeep Manjrekar Charts and Charting in Excel 3 December 4th 04 06:18 AM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"