Average Issues

[tompich]

If you take a look at this spreadsheet.

I want to calculate the average "Resolution Time" and i want it to be displayed in "Resolution Time" within the "Statistics" Worksheet.

Now, i tested the average calculation within the RiskOpsDetails worksheet highlighted in red and the right answer appears. However the same calculation done in the "Statistics" worksheet brings up an answer of 0.25 which looks very wrong.

Any clues? when its the same calculation?

[Dean England]

The cell in Statistics is now formatted as number. If you change the format to Custom (h:mm) you get the same number as on RiskOpsDetail. Is that what you want?

Dean

[tompich]

Sound as a pound !