Time column to get begin and end

[Tinus1905]

Hi,

I have one time column with different times. For example: 12:43:00 and 14:12:00.

I want a second column like this: 

Column1   Column2

12:43:00    12-13

14:12:00    14-15

I cant find the formula for this. 

[speedramps]

You can pad values before 12 with a leading zero like like

= Table.AddColumn(#"Changed Type", "Custom", each Text.PadStart(Text.From(Time.Hour([Time])),2,"0")
& "-" &
Text.PadStart(Text.From(Time.Hour([Time])+1),2,"0"))

[Ahmedx]

try this

[speedramps · Accepted solution]

In Power Query add a custom column

This solution works! So please click accept solution and thumbs up button

= Table.AddColumn(#"Changed Type", "Custom", each Text.From( Time.Hour([Time]))
& "-" &
Text.From(Time.Hour([Time])+1))