Donut clock to highlight busy hours

[Karthik Thandapani]

Hi,

I have a requirement to show the user's busy hours in a chart/diagramatic representation. I have a table where the list shows user's busy hours like 7:00 AM to 8:00 AM, 10:00 to 10:30 etc. Basically this representation will help us to quickly & easily find his availability time & assign some work in advance. Can anyone help me on this.

Please see the attached file.

Thanks,
Karthik

 

[Luke M]

Rather than a donut chart, which is a convoluted chart and hard to read, take a look at this idea. I setup some formulas to "bin" the given times into different buckets, and then plot them on a column chart. Increased height of chart indicates how busy that time period is, and chart can be read from left-to-right for time progression.