Normalzeit in Industriezeit (Dezimalzahl) umrechnen und umgekehrt

 

Normalzeit in Industriezeit (Dezimalzahl) umrechnen

--- SCHNIPP ---

(time as text) as number =>

let

    timeList = Text.Split(time, ":"),

    hour = Number.FromText(timeList{0}),

    minute = Number.FromText(timeList{1}),

    second = Number.FromText(timeList{2}),

    decimalTime = hour + minute/60 + second/3600

in

    decimalTime

--- SCHNAPP ---

Industriezeit in Normalzeit umrechnen

--- SCHNIPP ---

(dezUhrzeit as number) as text => 

let

    timelist= Text.Split(Text.From(dezUhrzeit),","),

    hours = Text.PadStart(timelist{0},2,"0"),

    minute = Text.PadStart(Text.From(Number.RoundDown(Number.Mod(dezUhrzeit * 60,60),0)),2,"0"),

    second = Text.PadStart(Text.From(Number.RoundDown(Number.Mod(dezUhrzeit * 3600,60),0)),2,"0"),

    normaltime = hours &":"& minute &":"& second

in

    normaltime

--- SCHNAPP ---