I have been using Microsoft’s Performance Monitor (perfmon) to capture data that hopefully allow me to understand the I/O bottleneck my Windows 2003 R2 server is experiencing only occasionally.
Converting Perfmon timestamps to a readable format in Excel
I’ve saved this data as a .csv file, and import it into Excel so I can analyze the raw data. The problem is, the timestamp column is in some indecipherable format that doesn’t map to actual time.
I did some playing around with the cell formating in Excel, and this is how I was able to get the Perfmon timestamp displayed in a usable format. I’m using Excel 2002 in this example, so you may need to adapt the instructions to your environment.
1. Import the Perfmon .csv file into Excel
2. Right click the timestamp column, which is column A for me
3. Select Format Cells
4. On the Number tab, select Custom Category
5. In the Type box, enter the following:
Note there is a space between the yyyy and hh
Press OK, and your time stamp column should now be in a human readable format!