Hello,
I have a spreadsheet that gets sent to me every day. The time values are displayed as follows: "Sat 12:00 AM", "Sat 12:01 AM", etc. I would like to figure out a way to extract just the time (get rid of the "Sat"). I've tried using the conventional time extraction formulas, however it...