Convert 24 Hr TIME

[TheRevenant]

I have a column of time data in 24 Hr time:
Time
625
844
1241
1566


Where 625 is 06:25 AM.


How can I convert this into a usable form for PowerBI? I tried the following DAX query in the advanced editor Column = CONCATENATE(CONCATENATE(LEFT([Time],LEN([Time])-2),":"),RIGHT([Time],2))
but receive the following message: Expression error: The name 'CONCATENATE' wasn't recognized. Make sure it's spelled correctly.
Thank you,

 

[mole999]

when does 15:66 occur ?

 

[TheRevenant]

Thanks for catching that. should be 15:56. It's just an example, I just need to convert it.

 

[TheRevenant]

THis also has nothing to do with DAX. It's Power Query or M. Sorry I'm new to this.

 

[Comfy]

You could try this:

Excel 2010
	A	B	C	D
1	Times In		Times Out
2	625		06:25:00 AM
3	844		08:44:00 AM
4	1241		12:41:00 PM
5	1556		03:56:00 PM
6
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Times In", Int64.Type}}),
    AddCol_Hours = Table.AddColumn(#"Changed Type", "hours", each [Times In]/100),
    ExtractChars_Mins = Table.TransformColumns(AddCol_Hours, {{"Times In", each Text.End(Text.From(_, "en-GB"), 2), type text}}),
    #"Changed Type1" = Table.TransformColumnTypes(ExtractChars_Mins,{{"Times In", Int64.Type}}),
    RoundHours = Table.TransformColumns(#"Changed Type1",{{"hours", Number.RoundDown, Int64.Type}}),
    AddCol_Times = Table.AddColumn(RoundHours, "Times Out", each #time([hours],[Times In],0)),
    RemoveCols_AllOther = Table.RemoveColumns(AddCol_Times,{"Times In", "hours"})
in
    RemoveCols_AllOther