How to filter time into 3 shifts like 6am - 2pm, 2pm - 10pm and 10pm to 6am in excel

Riny_van_Eekelen 

In general it's not necessary to keep separate table with groups, they could be calculated as

= Table.TransformColumns(#"Inserted Hour", {{"Hour", each Number.Mod(Number.RoundDown((_-6)/8)+1,3)+1, Int64.Type}})

However, table is useful if shifts have different hours long.