Modify Date and Time

Hi everyone. I really need some help with modifying stuff in excel

Here's the situation: (please refer to attached picture)

- Column B is a column for a Date. The format is YearMonthDay. For example, if I have 20000105 , the first 4 digits is the Year, the 2 digits after that is the Month and the last 2 digits is the Day. So that would be January 5, 2000. I need to change 20000105 to this format: 1/5/2000 or to some other regular date format so that sorting can be done by date. This has to be done for all cells in Column B.

- Column C is a column for Hour(or Time) . The format is HourMinuteSeconds . The hour is military time. For example, if I have 150018 , the first 2 digits is Hour, the next 2 digits is Minute and the last 2 digits is Seconds. So that would be 3:00:18 or Three o'clock 18 seconds. I need to change 150018 to this format: 3:00:18 or some other regular time format so that sorting can be done by time. This has to be done for all cells in Column C.

Note that time can also appear as something like 94936 wherein only the first digit is the hour. So this would be 9:49:36 or Nine forty nine and 36 seconds.

If anyone can suggest a macro for this it would be much appreciated. Thank you.