Notes

Custom1 = Table.ColumnNames(Source),
#"Converted to Table" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Added Custom2" = Table.AddColumn(#"Converted to Table", "Custom", each Date.FromText([Column1])),
#"Kept Errors" = Table.SelectRowsWithErrors(#"Added Custom2", {"Custom"}),
ColumnNames = #"Kept Errors"[Column1],
Custom2 = Source,
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Custom2, ColumnNames,"Date", "Shift"),
#"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Other Columns", "Date", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Date.1", "Date.2"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type text}, {"Date.2", type date}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Date.1", "Day"}}),
#"Split Column by Delimiter1" = Table.SplitColumn(#"Renamed Columns", "Shift", Splitter.SplitTextByEachDelimiter({"("}, QuoteStyle.Csv, false), {"Shift.1", "Shift.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Shift.1", type text}, {"Shift.2", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type1",")","",Replacer.ReplaceText,{"Shift.2"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","#"," ",Replacer.ReplaceText,{"Shift.1"}),
#"Split Column by Delimiter2" = Table.SplitColumn(#"Replaced Value1", "Shift.2", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"Shift.2.1", "Shift.2.2"}),
#"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"Shift.2.1", type time}, {"Shift.2.2", type time}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type2", "Date.2", "Date.2 - Copy"),
#"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Duplicated Column", {{"Date.2 - Copy", type text}, {"Shift.2.1", type text}}, "ibb-NG"),{"Date.2 - Copy", "Shift.2.1"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"In Time"),
#"Duplicated Column1" = Table.DuplicateColumn(#"Merged Columns", "Date.2", "Date.2 - Copy"),
#"Merged Columns1" = Table.CombineColumns(Table.TransformColumnTypes(#"Duplicated Column1", {{"Date.2 - Copy", type text}, {"Shift.2.2", type text}}, "ibb-NG"),{"Date.2 - Copy", "Shift.2.2"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Out Time"),
#"Changed Type3" = Table.TransformColumnTypes(#"Merged Columns1",{{"In Time", type datetime}, {"Out Time", type datetime}}),
#"Added Custom" = Table.AddColumn(#"Changed Type3", "CST In Time", each DateTimeZone.SwitchZone(DateTime.AddZone([In Time],0),CST)),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "CST Out Time", each DateTimeZone.SwitchZone(DateTime.AddZone([Out Time],0),CST)),
#"Added Custom3" = Table.AddColumn(#"Added Custom1", "Time", each DateTime.ToText([In Time],"HH:mm:ss")),
#"Added Conditional Column" = Table.AddColumn(#"Added Custom3", "Custom", each if [Time] = "00:00:00" then [Shift.1] else [In Time]),
#"Added Conditional Column1" = Table.AddColumn(#"Added Conditional Column", "Custom.1", each if [Time] = "00:00:00" then [Shift.1] else [Out Time]),
#"Removed Columns" = Table.RemoveColumns(#"Added Conditional Column1",{"In Time", "Out Time", "Time"}),
#"Renamed Columns1" = Table.RenameColumns(#"Removed Columns",{{"Custom", "Time In"}, {"Custom.1", "Time Out"}}),
#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"Id", "Employee", "Vertical", "SubVertical", "Account", "Team", "Designation", "Grade", "Day", "Date.2", "Shift.1", "Time Out", "Time In", "CST In Time", "CST Out Time"}),
#"Changed Type4" = Table.TransformColumnTypes(#"Reordered Columns",{{"CST Out Time", type datetimezone}, {"CST In Time", type datetimezone}}),
#"Renamed Columns2" = Table.RenameColumns(#"Changed Type4",{{"Shift.1", "Shifts"}, {"Date.2", "Date"}}),
#"Added Custom4" = Table.AddColumn(#"Renamed Columns2", "Custom", each DateTimeZone.ToText([CST In Time],[Format="HH:mm:ss"])),
#"Added Conditional Column2" = Table.AddColumn(#"Added Custom4", "Custom.1", each if [Custom] = "12:30:00" then [Shifts] else [CST In Time]),
#"Added Custom5" = Table.AddColumn(#"Added Conditional Column2", "Custom.2", each DateTimeZone.ToText([CST Out Time],[Format="HH:mm:ss"])),
#"Added Conditional Column3" = Table.AddColumn(#"Added Custom5", "Custom.3", each if [Custom.2] = "12:30:00" then [Shifts] else [CST Out Time]),
#"Removed Columns1" = Table.RemoveColumns(#"Added Conditional Column3",{"CST In Time", "CST Out Time", "Custom", "Custom.2"}),
#"Renamed Columns3" = Table.RenameColumns(#"Removed Columns1",{{"Custom.1", "CST In Time"}, {"Custom.3", "CST Out Time"}}),
#"Reordered Columns1" = Table.ReorderColumns(#"Renamed Columns3",{"Id", "Employee", "Vertical", "SubVertical", "Account", "Team", "Designation", "Grade", "Day", "Date", "Shifts", "Time In", "Time Out", "CST In Time", "CST Out Time"})
in
#"Reordered Columns1"