Have CSV file of events that occurred during a year for a home service dept. Each line has date, call type, time of call, time arrived at location, time finished and other fields but those are what's involved here. Times are in 24hr format already.
To get better idea of when calls occur that are causing overtime and peak periods during month/year, wanted to show them in a chart with date as the vertical, and times as horizontal.
I've made a VERY rough partial mockup in image editor below...The red lines are time from call received to arrival, and green from arrival to call finished...obviously on a chart, I'd have gridlines showing but wanted a quick pix to give basic idea of what I need to create.
One possible issue is that a given call may overlap days so would need to show the parts relevant on each day.
I'm not that much of expert in Excel but have done a fair amount of things using my old but trusty W2K vers...i do have Open Office 3.3 available as alternative but mostly use the 2K vers.
I've got vison issues so extensive searching here is somewhat of a problem and not even sure what to look for...so hope someone can give me some pointers...
thanks in advance!
To get better idea of when calls occur that are causing overtime and peak periods during month/year, wanted to show them in a chart with date as the vertical, and times as horizontal.
I've made a VERY rough partial mockup in image editor below...The red lines are time from call received to arrival, and green from arrival to call finished...obviously on a chart, I'd have gridlines showing but wanted a quick pix to give basic idea of what I need to create.
One possible issue is that a given call may overlap days so would need to show the parts relevant on each day.
I'm not that much of expert in Excel but have done a fair amount of things using my old but trusty W2K vers...i do have Open Office 3.3 available as alternative but mostly use the 2K vers.
I've got vison issues so extensive searching here is somewhat of a problem and not even sure what to look for...so hope someone can give me some pointers...
thanks in advance!
