How do I make a chart based upon time sheets?

K

Kevin0612

I have the data as follows:
Name Time In Time Out Time In Time Out (to account for lunch
breaks). What I want to do is create a chart that graphically shows how many
people are in the building at any given time. So I want the times on the
bottom and the person's name on the vertical axis, and then have a line that
runs across the cells that the person is on the clock. Any ideas?
Thanks.
 
Top