I have an excel spreadsheet, specifically it's a list of hardware devices with various details dumped out of our system. Each row has a 'last modified' time/date value in the format of 09/09/2006 10:37 etc
I want to be able to create a graph where I can see which times of the day most changes occured?
The table basically looks like this:
Address Subaddress Active Created Modified ModifiedBy 10.96.48.58 2003 no 04/05/1997 15:58 14/09/2006 10:37 djc2 10.209.35.34 2009 yes 16/05/1997 18:01 06/07/2009 16:08 vm5
So this means the graph will have to ignore the date pretty much and only look at the time, with the time of day along the x axis and number of changes on the y axis. Can this even be done easily in Excel 2002?