I am trying to report on trip activities and have a large table of data for any given trip.

For each trip there may be up to 3 reasons for delay recorded. My problem arises in the way in which the data is presented in the excel extract.

Which is to say that for a trip delayed for one reason I get the following in a single cell:
93/00:20 - i.e. delay reason 93 for 20 minutes.

For two delay reasons I get the following in a single cell:
04/41/00:20/01:10 - i.e. delay reason 04 for 20 minutes and delay reason 41 for 1 hour and 10 mins.

For three delay reasons I get the following in a single cell:
05/74/75/00:32/00:23/01:35 - i.e. delay reason 05 for 32 minutes, delay reason 74 for 23 minutes and delay reason 75 for 1 hour and 35 mins.

Sample of how the total data is presented is as follows

Cell A1 Date, Cell A2 Trip number, Cell A3 Planned departure time, Cell A4, Actual departure time, Cell A5 Delay reasons and times.

I am trying to reorganise the data in such a way that I can count and sum delay reasons and times for any given trip, date or reason.

Unfortunately I am unable to write VBA and macros as I've no formal excel training. Have been experimenting with left, right and if commands to do it but haven't been able to get anywhere.

Hopefully somebody either has a silver bullet or fancies a challenge?

Thanks