Project is to take the attached text file and to copy and paste into an Excel workbook.
VBA macro should then be written that can be run to re-format the input text file data and output onto a new Excel worksheet in the new format.
The formatting needs to be updated so that the rows in the input data file that are in following format…
Date InTime In Date OutTime Out Ab. Hrs.
09/03/201213:19 10/03/201200:47 11.4672
…are re-formatted so that each of the data components …
