• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Analysing a Gantt Chart

B

bgriff

New Member
Greetings!

I'm putting together an employee schedule template in the form of a Gantt chart and am trying to figure out a quick way to analyse some of the data.

On the vertical axis, I've got employees' names. On the horizontal axis, a day's worth of time in thirty minute increments. Each bar on the chart represents the duration of an employee's shift.

What I'd like to know, is what our coverage is during each half hour increment (i.e. - how many operators have I got from 10:00 - 10:30? 10:30 - 11:00? etc). Is there an easy way to pull that info directly from the chart?

Would appreciate any suggestions - thanks!
 
Thanks Somendra - and thanks for the swift reply!

I'm not quite sure how to do that. Currently I've just got four columns of data - Column A: Employee Name, Column B: Start time, Column C: Duration of Shift & Column D: Finish Time.

The Duration of the shift is calculated using the following formula -

=MOD(D2-B2,1)

Any ideas?
 
You must log in or register to reply here.
Back
Top