I'm trying to chart growth in our nightly backups. The three values I'm using are the date of the backup, the backup job size in bytes, and the time the job took to completely in hh:mm:ss.
Using Excel 2010, I'm having a devil of a time convincing Excel that the elapsed time is a number of hours, minutes, and seconds, and not a time of day.
I've tried using Time formats, and a few custom formats that appear not to use an AM/PM value, but all to no avail. The values are still firmly showing an AM/PM in the function box.
I also tried removing all " AM" from the spreadsheet after setting the format to one of these AM/PM-less formats. No difference, the AM/PM's are still there.
Once I can cajole Excel into accepting the values for what I want them to be and not what it thinks they ought to be, I'd like to chart them using two vertical axis': One for the job size and one for job time. The horizontal axis would be job date. This should allow me to graphically represent the growth of data we backup and the time it takes to backup that data and compare these values relatively.
UPDATE clarifying based on first response:
It is not important to me how the data is displayed. What is important to me is that the data I enter reflects correctly what it is that data truly is.
For a value entered of 6:03:23, I do not mean the value represet 3 minutes and 23 seconds after 6 o'clock in the morning. That value should reprsent 6 hours, 3 minutes, and 23 seconds of time, regardless of where or when that period originated. It is a measurement, not a reference point.
Excel seems to think I am refering to the reference point of time on the clock, not to a measurement of time that has elapsed during a process.
So long as Excel thinks I'm refering to a point of time and not a measured chunk of it, it will not be able to recognize what it is I am comparing and this will not graph it appropriately.