I have some start and end times in an excel spreadsheet that are written in 24hour clock, but with a colon between the hours and the minutes. I have tried using the format cells option, and that does not work. I need to successfully convert Cell to how the AM or PM with the time so that whenever the spreadsheet is sorted, items counted, etc , the formulas used to convert the time will not cause additional issues. I have attached an example spreadsheet. Please assist. Thank you.