Total Brain Fart

[SoulAssassin]

So I'm trying to compare backup times of these servers under different scenarios. In the first scenario the average backup time is 40:02 in the second the average is 34:52. I need to represent the % increase from the second scenario from to the first.

34:52/40:02=87.09%-1 = -12.91% difference

40:02/34:52=114.83%-1 = 14.83% difference

Which one is it?

I'm totally having a brain fart day, I thought it was 14.83 then I started thinking about it too hard. Slept like crap last night and got a caffeine headache and...well, I'm just trying to justify having a brain fart.

 

[KLin]

42%

 

[dullard]

The first is 14.82% longer than the second.

The second is 12.91% shorter than the first.

 

[Wizkid]

(40:02 - 34:52) / 34:52

 

[jamesave]

convert all to seconds first. then (seconds1 - seconds2)/seconds2 * 100 to get the percent increase

 

[Fourier Transform]

Originally posted by: Wizkid
(40:02 - 34:52) / 34:52

Seconded

Originally posted by: jamesave
convert all to seconds first. then (seconds1 - seconds2)/seconds2 * 100 to get the percent increase

Also seconded (no pun intended).

 

[dullard]

Originally posted by: jamesave
convert all to seconds first. then (seconds1 - seconds2)/seconds2 * 100% to get the percent increase

Fixed.

 

[SoulAssassin]

Originally posted by: jamesave
convert all to seconds first. then (seconds1 - seconds2)/seconds2 * 100 to get the percent increase

Excel will do the calculation of seconds for you so that's unnecessary but point taken none the less. I thought it was 14.83% (which is what this works out to) but like I said I was just thinking about it way too hard.



edit: btw...thx for the sanity check guys. Owe everyone a beer.