Calculating Average Server Times

Hey Everyone,

I need to show a chart that displays between 0 & 120 Seconds (including milliseconds) for Server Loading times tested daily and, then average out the worst servers based upon the daily values entered.

In example;

06/15/2017 - 4.02 Seconds
06/16/2017 - 22.92 Seconds
06/17/2017 - 11.03 Seconds
06/18/2017 - 5.90 Seconds
06/19/2017 - 4.62 Seconds
Average Server Loading Time - 9.69 Seconds

I've tried it with time. but, it makes the graph & charts go crazy. It also seems to try and switch the numbers to an actual time as in 01/01/1901 00:10 AM which, also messes up the charts.

I then tried it as currency or a value(number) and even generic. But, it's always incorrectly displaying in charts & graphs.

What would be the best way to accomplish this?

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work.

Hope this helps.

Pete

Had to make an extremely small replica. as uploading our actual data file has 50k / 100k entries. and, changed server names & removed IP's and other server info.

Originally Posted by FDibbins

How about if you add helper columns for each time and apply a factor (or say 100) to push the values up, then chart those? Although, I dont really see a problem with the charts you showed?

Can you walk me through that? I am brand new to excel :P