How to convert date/time column to time column with hours and minutes (hh:mm) in Power Query?

[SanchezDK]

Hi all, 

I have a Begin Time column of type date/time with data like: 

Begin Time

01-01-1998 05:56:12

01-01-1998 07:15:58

How can I convert this in Power Query to just showing time in a format with hours and minutes (NOT seconds)? 

Like this:

Begin Time

05:56

07:15

Hope that you can help. 

Best regards, 

Jacob

[PattemManohar]

@SanchezDK Please try this.. as as new column in Power Query

= Table.AddColumn(#"Changed Type", "Text Between Delimiters", each Text.BetweenDelimiters(Text.From([DateTimeVal], "en-GB"), " ", ":", 0, 1), type text)

[SanchezDK]

Hi pattemmanohar, 

Thank you for your reply. Your solution would work. However, I was looking for a way to transform the current column (instead of adding a new) and keeping the time format (without the seconds). 

Best regards, 

Jacob

[v-cherch-msft]

Hi @SanchezDK

You may use 'Format' for the column as below:

Regards,

Cherie

[SanchezDK]

Hi and thank you for uour reply. This is a very nice feature - however, I cannot figure out to do the same in Power Query. 

[v-cherch-msft · Accepted solution]

Hi @SanchezDK

You may refer to below:

= Table.TransformColumns(Source, {{"Begin Time", each Text.BetweenDelimiters(_, " ", ":", 0, 1), type text}})

Regards,

Cherie

[SanchezDK]

Hi Cherie, 

That works perfectly. Thank you very much.