Conditional formatting for time sheet

I need to conditional format a time sheet to fill in a colour from start time to end time. i.e the sheet is divided into columns showing every half hour ( B1 = 0030 , C1 = 0100, D1 = 0130, E1 = 0200 .. etc until 0000 hours)

How I have rows for different activities unter Column A . I also have for eg. "Sipping" tea is in A3. If I put time I started Sippin tea as 0100 in Cell AX3 and time I completed Sippin Teas as 0200 in AY3. The how do I get the cells to get filled from 0100 until 0200 in the range of cells in my time sheet.

I have attached the actual time sheet that requires the inputs.

Hi thanks.. I will stop despairing for now
Sorry I meant row 7

I want the cells in row 7 to be conditional formatted to get highlighted depending on the values of AZ7 and BA7. So in this case i want the range of cells from k7 to p7 to get a different colour.
I want the cells in row 7 to get highlighted for values between 0530(k4) and 0800(p4). So this means that the conditional formatting has to look up the values in row 4 based on the values in AZ7 and BA7 and then colour the range on cells in row 7 based on that. in the attachment provided I have manually coloured the cells , but i want conditional formating to do the same.

Sweet !!! .. it works.. yes I figured that the time in row 4 were much smaller than the values in AZ7 and were not working.. just could not figure out how.

BTW... Thanks a GAzzillion !!!