OK, I don't know how complex this is going to be but here goes. I have a worksheet that has time clock information. I also have a resource on the web to see some information and even export it.


In the exported data it looks as follows:

A1 contains an individuals name
B1 says times i.e. "8am to 5pm"


I would like a macro that takes the data from A1 and moves it to another worksheet in the B4 position down, and take the times from B1 and move the first time to the C4 position and the last time to H4.

If this isn't complicated enough, I need this to be in military time. Any help is greatly appreciated.