Excel im betrieblichen Umfeld

  neue Abfrage erstellen und in zB fxFolderFiles umbenennen --- SCHNIPP --- (FolderPath as text, WorksheetName as text) =>     let         Source = Folder.Files(FolderPath),         ExcelFiles = Table.SelectRows(Source, each ([Extension] = ".xlsx")),         ContentNameSpalte = Table.SelectColumns(ExcelFiles,{"Content", "Name"}),         ContentSpalte = Table.AddColumn(ContentNameSpalte, "Custom", each Excel.Workbook([Content],true)),         Arbeitsblatt = Table.AddColumn(ContentSpalte, WorksheetName, each [Custom]{[Name=WorksheetName]}[Data]),         Tabellen = Table.SelectColumns(Arbeitsblatt,{WorksheetName})     in         Tabellen --- SCHNAPP ---

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