Formula for calendar population

[didier]

hi guys,

Need your help

i have you help with a formula

i need to populate a calendar according to a table that i have.

at the moment i was able to do it for the time using the below formula:

{=IFERROR(INDEX($C$9:$C$72,MATCH(1,($O$10=$E$9:$E$72)*(N12=$F$9:$F$72)*($N$8=$I$9:$I$72)*($Q$11=$J$9:$J$72),0)),"")}

however now i would like to introduce the duration from 30 min to 4 hrs.

the result should be that the slot should be highlighted depending on the duration.
i have attached a screen shot of what my file looks like

Img Safe | Free Image Host | Home

any help would be appreciated

Thank you

 

[mart37]

change: (N12=$F$9:$F$72)
in: ($N12>=$F$9:$F$72)*($N12<=$H$9:$H$72)

 

[didier]

change: (N12=$F$9:$F$72)
in: ($N12>=$F$9:$F$72)*($N12<=$H$9:$H$72)

it worked perfectly thank you for your help