I'm looking for a way to isolate the times from cells.
This is START and END time, so I need the start time in one cell and the end time in another cell.
My idea was to use the =RIGHT or =LEFT formula. The problem I have is that the Hours in the time are sometimes 1 digit (e.g. 9:02 PM) and sometimes 2 digits (e.g. 10:17 PM)
Here's 3 examples of the raw data I have. I also have the option for my data to be without the parenthesis and its content, if that's makes it easier (e.g. 9:02 PM*to*9:48 PM)
9:02 PM*to*9:48 PM*(for*an hour)
9:44 PM*to*10:27 PM*(for*43 minutes)
10:17 PM*to*10:28 PM*(for*11 minutes)
The final goal I'm looking for is to have Start time / End Time / Duration in minutes. The duration should be able to handle if the start time is in PM and the end time is in AM (e.g. 11:50 PM to 12:10 AM)
Bookmarks