Hi, I am using Excel 2010 and I have a 6 spreadsheets with over 300 lines that I need to sort by time in a column that has date and time.
In column B I have date and time, I need to sort that out by time only.
Right now when I sort it, it sorts it by date and then by time, I would like it to ignore the date and just sort by time.
More helpful would be a way to automatically enter the number 1 in column A if the time falls in the range of 06:00 and 17:59 and enter the number 2 for the time range of 18:00 to 05:59.
Any help would be appreciated. I have attached a small sample.
sample.xlsx
Bookmarks