I have an excel file that lists events, one per row, with a Start Date/Time and End/Date Time. (within the same day).
I want to expand this data so I can report on hourly usage.
For example, I have an event that begins 12/1/2012 8:00am and ends 12/1/2012 5:00pm. I want to show that the event took place at 8am, 9am, 10am, 11am, 12pm...etc. and eventually put this into a bar chart. Any suggestions?
If the former, you can simply get the duration by using a formula
Finish and Start Time being cell references for those times.
This assumes that the data is in true date & time format.