0

I'm trying to make some statistical data on the performance of a specific task.

One of the data points gathered is how long time it took to run. I'd then like to compare that against the expected time to run and thereby know in percentage if the task performed better or worse than expected.

See example below:

Example

Thanks in advance :)

Improve this question
1
  • Since Super User is not a formula/script writing service, it would be best if you share with us what formula you have already attempted so we can help you solve this.
    – CharlieRB
    Aug 3, 2015 at 12:57

1 Answer 1

Reset to default
1

The formula on cell C3 should be:

=(B3/$B$2)-1

Copy down this formula to cells C2, C3, C4 and so on.

Select column C, right-click and select Cell format -> Percentage

Improve this answer
1
  • So simple, thanks. My own attempts where much more complicated.
    – Michael G
    Aug 3, 2015 at 13:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .