Converting seconds into day hours min sec

Question

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

marcelbeug · Accepted Answer

Preferably in Power Query. e.g.:&nbsp;&nbsp;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&nbsp;or otherwise&nbsp;in DAX:&nbsp;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)&nbsp;

Forum Discussion

Related content

Convert Days, Hours, Minutes and seconds in to Seconds

Convert Seconds to Hours

Convert seconds into hour minute and seconds

Convert Seconds to Hours and Mins

Convert Seconds to DD:HH:MM:SS