Formula to alter calculation dependant on drop down list value

Hi,
This is a continuation of a previous question that we sorted....

I have a spreadsheet that users fill in, they should use a comma to separate the different values that they might enter into a cell but they don't always, also they don't always use a Capital letter at the start of their code, hence some of the specifics we have had to create in the formula as it stands.

I can't alter the data collection section of the sheet but can add more sheets, reposition the reporting etc.

What I would like is the ability to pick a day and time from the drop down lists in the report section and have that alter the relevant results in the report section.
My gut says that some sort of lookup table would help but i can't figure it out. Can anyone help?

Data 2.jpg