Convert JSON Seconds & Nanos to DD:HH:MM:SS

[sa34techer]

I have a column in json format that collects seconds & nanos this way --> "{""seconds"":1714393064,""nanos"":0}"

Please help me convert this to DD:HH:MM:SS or date(if possible).

[Greg_Deckler · Accepted solution]

@sa34techer So like this?

let
    Source = Json.Document(File.Contents("C:\temp\testjson1.json")),
    #"Converted to Table" = Table.FromRecords({Source}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"seconds", Int64.Type}, {"nanos", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each #duration(0,0,0,[seconds]))
in
    #"Added Custom"