I've googled converting text to time, and for simple bits I have answers.. what I'm struggling to find is if it's possible to convert something like 8:00am-4:30pm (in one cell) to a Start and End time (two separate cells)
I'm working with something similar to this sample data...
![]()
Please Login or Register to view this content.
Converted start and end times would go into a new sheet with the data underneath each row (as in, 2 rows inserted under each analyst, start time, and then end time.)
Let me know if I can provide anything else here.
Bookmarks