In order to sort by times with the week, format the cells to show the day in the 7 days. If you wish to sort by the working day on the week regardless of the day, transform them to text by using the TEXT function. Recording of your macro begins https://www.customguide.com/google-docs/track-changes-in-google-docs