[RESOLVED] Want a challenge? SoonestDateTime 2

[longwolf]

I posted a similar question here:
http://www.vbforums.com/showthread.php?t=539532
But now I need something more robust.

I've put together some controls for a user to input Shop Hours and days.
It then formats the info into a string that can be stored in a DB.
There's more code that can take the string and set the controls.
Those parts are all working.



Here are some of the strings it can produce,
7 Days a Week, 24 hrs a day
Mon - Fri, 8:00 AM To 6:00 PM
Mon - Thu, 8:00 AM To 6:00 PM; Fri - Sat, 8:00 AM To 10:00 PM '''notice Sunday is closed
Mon - Wed, 10:00 AM To 4:00 PM; Fri - Sat, 24 hrs a day '''notice Sun and Thu are closed

Now I need a function that can take that date/time string and find the soonest time that the shop could be visited.
The function would be sent the BizHrs string and the soonest time you would be available.
It would return the soonest date/time that you could go there, i.e. a day and time of day when they'd be open.

(Frankly, I've intimidated myself with this one )
Edit: Removed the code, look below for the new upload