Hereby the cell:
"From 07/09/11 till 13/06/12
Ma Gesloten
Di Gesloten
Wo Open from 14:00 till 16:55
Do Gesloten
Vr Gesloten
Za Gesloten
Zo Gesloten
Meer uitleg : Geen lessen tijdens de schoolvakanties
"
I need to create a macro/script to extract 14:00 and 16:55 in above text, these are two timevalues (from and till). They need to be extracted each to a new cell in the same format HH:MM. Text is variable.
I have a variable column with values, so the macro/script needs to applie to a whole colum (range x:x)
Please advise!
Thx!
Bookmarks