Converting seconds into day hours min sec

[reacharihant]

I need to convert seconds into day hours min sec. How can I do it? 

[MarcelBeug · Accepted solution]

Preferably in Power Query. e.g.: 

let
    Source = #table(type table[Seconds = Int64.Type],{{4000},{40000},{100000},{1000000}}),
    Day    = Table.AddColumn(Source, "Day",   each            Number.IntegerDivide([Seconds],24*60*60),  Int64.Type),
    Hours  = Table.AddColumn(Day,    "Hours", each Number.Mod(Number.IntegerDivide([Seconds],60*60),24), Int64.Type),
    Min    = Table.AddColumn(Hours,  "Min",   each Number.Mod(Number.IntegerDivide([Seconds],60),60),    Int64.Type),
    Sec    = Table.AddColumn(Min,    "Sec",   each Number.Mod([Seconds],60),                             Int64.Type)
in
    Sec

or otherwise in DAX:

DAXDay   =     INT(Query1[Seconds]/(24*60*60))
DAXHours = MOD(INT(Query1[Seconds]/(60*60)),24)
DAXMin   = MOD(INT(Query1[Seconds]/60),60)
DAXSec   = MOD(    Query1[Seconds],60)

[reacharihant]

Thanks! Got it.