Employee working hours chart

[egoziyan]

G'day

I need some help, I am trying to make a bar chart that will show to hours the employees worked on a given day.

I want the chart to emphasis if there are 2 employees at the same time.

my data contain the date, worker name, entry time, exit time

in my view I see a chart with axis between 8:00 to 23:00

the Y is worker name and the bar will be from entry till exit.

Any help / example on how to achieve it will be appreciated

Thanks

Yaniv

[swuehl]

There are different solutions to this kind of request, one could be using an approach like I've demonstrated here

band time to cover fixed band time

[egoziyan]

Thanks swuehl

what I am trying to achieve is something like the picture.
it let me see clearly that between 12 until 13:30 there was 2 workers

[lironbaram]

Hi

have a look

at the attach example , may be it'll will help you

[egoziyan]

Thanks I am looking into it.

Do you know how do I make the chart to start always from 8 and to see the worker time on the actual time ?

[petter · Accepted solution]

Can this be something that works for you:

[egoziyan]

Exactly what I was looking for

Thanks alot

[petter]

Thanks, I am happy to help