How do i format my data to create a column chart?

Here is how you can do it. First of all, unpivot the connection columns in Power Query to get:

 Next create a Calendar Table and a Dimension table for Conecctions:

Create the relationships between the corresponding fields in the model

Create the measures for the visuals:

Sum Time = 
SUM('Table'[Time])

Since you can't use a Time format in a bar chart, convert this sum into seconds 

Time in seconds = 
HOUR([Sum Time]) * 3600 + MINUTE([Sum Time]) * 60 + SECOND([Sum Time])

Now create the visual using the date field from the calendar table (make the axis categorical), the connection field from the dimension table for the legend and  the measure(s). In the bar chart you can add the [Sum Time] as a tooltip.

I've attached the sample PBIX file