MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help! Workinghours displayed in a chart, impossible??

Posted by ESPEN on January 08, 2001 11:31 PM

How can I show when a employee has his workingperiod, in a 24 hours chart?



Posted by M:force on January 09, 2001 1:48 AM

Please give us some more clues about what you are trying to do.

Posted by espen on January 09, 2001 6:06 AM

At my job we would like to see on a "ganttchart" who is working when. I'm on an airport, and we need to easily see who's at work at which arrivels/departures.
But when I have "series 1" whith info. about WHEN employee starts to work, ex 15:00, it is displayed from 00:00 to 15:00. And then when "series 2" is containig info about HOW LONG the employee work, ex 07:00 hrs, it seems like the computer makes it 31 hrs. 24 hrs more than I've written.

If only knew how to make series 2 correct, I know how to make series 1 invisible.

Do you know if there are any examples of this type of chart?

I hope that you can help me out with this one, because I haven't found this question in the archive.



Posted by Aladin Akyurek on January 09, 2001 6:40 AM

This might help:

Posted by espen on January 09, 2001 2:42 PM

Hi Aladin Akyurek

I've checked out the lacher site, and printed out the macro. But I've never used macro, and I don't understand the logic that there propably are in this code. And the example was for three "employees", but I have somewhere between 12-18.

Is it not possible to make this less complicated?

espen :-)

Posted by espen on January 09, 2001 3:04 PM

I checked out Lachers site, but those macro code thing was to heavey, I've never been into those things. Is there a simple way to do it, or how can I learn about macros. I need a gnattchart for 12-18 employees.


Posted by Aladin Akyurek on January 09, 2001 3:18 PM

I'm sorry, Espen, I can't help you on this. I just passed the Lacher example to you, as a start point, say.


Posted by espen on January 09, 2001 5:28 PM


do you know of any sites where to learn how the macrocode system works? It seems just like a lot of words whithout any "red line" to catch up with.


Posted by Tim Francis-Wright on January 10, 2001 1:28 PM

There's a simple Gantt chart at

You'll want to do the following:
1. Reformat the dates in the worksheet and
the chart x-axis to be times
2. Change the formula in the duration column
so it's (end time) - (beginning time), not
(end date) - (beginning date) + 1
3. Redefine the x-axis minimum, maximum,and
4. Change the source data as you need
(right-click on the chart to change the source
data range).

This doesn't require any macros, unless you
want to do something extra fancy.

Good luck!