Excel chart for hours worked

I don't use Excel charts often, but this chart is becoming a real challenge. I want to create a simple stacked column chart displaying the hours worked per day based on a table with date/time data. So far this was unsuccessful and none of the examples I found online offer this feature.

X-axis are the times 00:00 to 24:00
Y-axis are the dates in one month

I included a sample table with the values of one month.

This chart is intended to display the non worked periods in a day. Thus every day, the complete time of a day (0-24) should be displayed, and the non worked hours should be empty in a column. I wonder if this is even possible, or should I first create a calculation for the non worked periods and push both non worked and worked hours in a temporary table and create the chart from there?

Art.

Hi Ben. Thx for your help, although I believe I had to be more specific.

In my case I want to create a chart displaying the actual times worked. For example, on the 2nd of January from 15:11 until 16:31 and from 14:58 until 15:03. Thus 00:00 until 14:57, 15:04 until 15:10 and 16:32 umtil 23:59 are blank columns on that day. Dates where there were no working hours should be displayed as well but empty (my goal is to display a complete month in a chart).

Thx, that formula did the trick. After some modification and a VBA procedure I managed to display different time intervals as well.
Attachment 859292

The VBA code is essential if you want to switch between the time intervals. I put mine in my personal macro file (personal.xlsb). The command buton in the chart sheet must be linked to this macro.

Please Login or Register  to view this content.

Thx all for your help!