Ok, my friend is trying to learn Excel VBA and get into RAD development. I am going to set a number of challenges which I am going to call a ‘G Challenge’ 😛
So the first. Take a string in the format :
where the format is :
In VBA I would like 2 things.
- The string back in the format dd-mmm-yy hh:mm
- An actual date serial
Example above would go to
- 24-Nov-2010 17:06:15
Go! I would use 2 seperate functions to start off with.
Answers will be forthcoming in a post G Answer I