Total hours in decimal format
Arrival time Exit time Hours 24/03/2020 21:15 25/03/2020 04:14 6.97 23/03/2020 07:00 23/03/2020 09:00 2 23/02/2020 07:00 25/03/2020 04:14 741.23
Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], HoursDec = Table.AddColumn(Source, "Hours", each Number.Round(Duration.TotalHours([Exit time]-[Arrival time]),2)), TSC = Table.SelectColumns(HoursDec,{"Hours"}) in TSC
Bookmarks