Fill Cell(s) with colour based on duration/time and keywords

Hi everyone, I need some help on a urgent request.

I'm trying to make a timetable/schedule system which basically fills certain cells selected based on duration/time of a specific word/phrase for example, in this picture

eZAXAFw.jpg

As you can see, Jessica is booked in at 11am, M+P duration is 45mins as you can see, the highlight stops at the 11:45am. B/Dry starts at 10:30am and ends at 11am. Is this function possible in some way?

The way I currently do it is manually highlight the cells however I was wondering if this operation could be done automatic?

So if I select for example, D7 and write M+P there, it would highlight 4 cells from D7, which would result D7,D8,D9,D10 highlighted.

If anyone could help me, I would really appreciate this as this up for a very important assignment.

Thanks everyone~!