Extract And Use Information In A Comment Box

My user has data in a comment in a cell that provides additional information about the data in the cell. He does not want to have to retype that information into another spreadsheet but wants it to automatically populate.

For example:

Column Headings: A1 = Tardy; B1 = Absent; C1 = Detention

Data in the following cells: A2 = 2; B2 = 1; C2 = 3

Comments are: A2 = Smith - 10 min, Jones - 5 min; B2 = Adams - Sick; C2 = Brown - Talking, Green - Talking, Gray - Sleeping

He wants another workbook that has a column for each name in three separate tables, 1 each for Tardy, Absent, and Detention. He wants the Tardy table to show 10 min under Smith, 5 min under Jones, etc.

Is this at all possible? I will say that I tried to get him to change his spreadsheet so that he inputs the data into the three separate tables then summarizes it in the sheet he presently has but he cannot change the original sheet. It is a shared sheet by many of our office locations and changing it is not an option.