multiple start/stop times in excel chart

Times are just numbers (fractions of a day), so they should chart up just fine. Without knowing more detail about what you are doing (chart type, how you are trying to incorporate times in your chart, etc.) I don't think we can provide much specific help. Can you explain in more detail what you are doing -- perhaps upload a sample spreadsheet?

That looks like a basic Gantt chart. Most Gantt charts are stacked bar, where your picture shows a stacked column, but that doesn't change the basic ideas. Here's how I would proceed

0) Hopefully useful links about creating charts in Excel:
stacked bar/column tutorial: https://www.extendoffice.com/documen...umn-chart.html
basic Gantt chart tutorial (based on duration in days, but the same basic idea applies to times): https://www.officetimeline.com/gantt-chart-excel
introduction to how Excel stores dates and times: http://www.cpearson.com/Excel/datetime.htm
1) What is the most "starts -- stops" intervals you expect to ever see in a day? Set up that many pairs of columns.
2a) Enter data. I would expect a format like this:

Please Login or Register  to view this content.

2b) Note that I enter the values as decimal hours at this point, because I find that easier to enter. Also note that I subtracted each time pair in my head to get the durations. If you want to take advantage of Excel's time formatting, you need to convert these values to "fraction of a day" by dividing everything by 24 (Enter 24 in a convenient cell -> Copy this cell to clipboard -> select these durations -> Paste -> Paste special -> Divide -> Format cells as desired time format).
2c) If you don't want to compute durations in your head, it would be easy enough to enter start and end times in the same table format, then use simple subtraction formulas to get the durations. Just remember that you are going to build the Gantt chart based on durations, not the original time data. If you go this route, it will be important to get your times entered in a way that Excel will recognize them as time. Based on your sample, that is probably easiest by entering hh:mm AM/PM like you did in column B and C, but you must include a space before the AM/PM to get Excel to recognize the time entry.
3a) With your table of durations set up, select the table -> Insert -> Chart -> Stacked column (or bar if you decide you like the horizontal arrangement better).
3b) Hopefully Excel correctly interpreted the chart. If not, go into the Select Data dialog and fix Excel's mistakes (try not to grumble too much).
3c) Format data series as desired (mostly this is selecting the columns/bars between the End times and the Start times where the RSL was absent to have no fill). If needed, format vertical axis (horizontal axis if you changed to a stacked bar chart) so that it shows time in the desired format.
3d) Other formatting as desired.

Note that most of the work in creating a Gantt chart is in building the table of values that feed into the chart. If you spend the necessary time getting a good arrangement of the data, the chart will be easy to create and maintain. If you try any shortcuts in step 2, you will probably have trouble with your Gantt chart.

Does that help? Where do you get stuck?

I had a different approach with a stacked barchart.

Hi Judy,
I extended the sheet to 4 months.
Is this what helps you ?

Glad to help you and your friend with RLS.
Please let me know if the Dr could use the chart info as it is presented in this format.