I have a year's worth of data in a spreadsheet that I'd really like to analyse in the form of a line graph - before anybody asks this data wasn't put together by me for this particular task so the spreadsheet wasn't designed to output the specific data I require.
For the sake of an example, lets say the spreadsheet is about usage of meeting rooms (it isn't but the exact nature of the data is confidential so I cannot divulge it).
I have a list of when each meeting room was booked (start time and finish time in separate columns). What I would like to do is to plot a graph with 30 minute intervals on the x axis and the number of meeting rooms in use at that specific time on the y axis. Is this possible or do I need to manually extract further data? Like I say I have a year's worth of data (in weekly sections) so would rather not have to manually do anything.
Any help would be very much appreciated.