Hi everyone! Thank you for looking at my question. I have searched around but the answers found look to not work for my issue. I need to pull just the shift time from an associates schedule...
Example of the different formats of the shift descriptions pulled from reporting... They are all over the place and changing the description in the database is not an option(wish it was).
Mon - Fri 15:30 - 24:00
Su - Mo , Fr - Sa 16:30 1:00
Mon-Fri 0630-1500
W,F,Sa 0730-1800 Thu 0730-1230
Sun 0730-1800; Sat 0700-1730
Sun-Wed 0630p-0500a
I already have this formula extracting the days scheduled...
=LEFT(BA2,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},BA2&"0123456789"))-1)
If anyone has a solution i would appreciate it greatly.
Bookmarks