Charting sleep and wake throughout the day

I am trying to create a chart that illustrates the times a person is asleep throughout a 24-hour period. I am having trouble getting multiple bars (chunks of sleep) per date. Also, the bars are continuing past the end of the data range. Any help would be appreciated. Thanks. Here's a sample of the raw data:


Date Fell Asleep Duration Fell Asleep Duration Awoke Awake Duration
4/28 1:30 AM 6:30
4/29 2:30 AM 5:45
4/30 3:30 PM 2:00 5:30 PM 3:00
5/1 11:00 PM 1:00 12:00 AM 8:00
5/2
5/3 11:00 PM 11:30 10:30 AM 12:00
5/4 8:30 PM 2:30 11:00 PM 10:00

mdefalco4,

Good afternoon and welcome to the forum. It is typically very helpful if you are able to post a sample, or the actual, copy of the workbook you are working on. I know for me, I'm very visual and find it helpful when trying to problem solve. I'm not sure I'll be able to help but others will be along as well that can help.

Matthew