Excel im betrieblichen Umfeld

  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 ---