Hello, I'm trying to create a simplistic weekly status indicator bar chart. Over the course of 1 week (168hrs), I would like to use a single bar to indicate 1 of three statuses using unique colors for each status. Currently the status is entered as a time and date into a table that looks like this:

Start Time End Time Total Time
STATUS 1 1/10/16 0:00 1/10/16 1:00 1
STATUS 2 1/10/16 1:00 1/10/16 6:40 5
STATUS 1 1/11/16 4:45 1/12/16 13:00 32
STATUS 2 1/12/16 13:00 1/12/16 23:00 10
STATUS 1 1/13/16 12:00 1/15/16 11:00 47
STATUS 2 1/15/16 12:00 1/15/16 19:00 7
STATUS 1 1/16/16 0:00 1/16/16 23:59 23

Ideally, my horizontal bar chart would start at 1/10/16 0:00 and end at 1/16/16 0:00 separated in 1 hour increments. Unique colors would display for "Status 1", "Status 2", and a third color for when no status is identified. Any advice on this? Thanks!