Wednesday, May 9, 2018

yogi_Sort By 'Day And Time' When 'Day And Time' Together Have Been Entered As Text

Google Spreadsheet   Post  #2444

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-09-2018

question by: ScriptTrouble
https://productforums.google.com/forum/#!topic/docs/5ekVC8iavOE;context-place=forum/docs
How to sort by day and time not a to z
I have a schedule for employees. But when we sort the sheet it puts everything by a to z the I would like it to actually put the response in the right order starting Monday morning. The problem is Friday is always first. but more importantly, 1 am is followed but 1 pm.

https://docs.google.com/spreadsheets/d/1DJp0AwtGwfCm7nPzLEh-OwV89cIMWlm0oWTmYK7LVOo/edit?usp=sharing