Conditional Formatting with Time Duration...

Try changing the CF formula for column Q to

=AND($O1*24<12,$O1<>0)

and for column P to

=AND($O1*24<6,$O1<>0)


BTW: I would encourage not applying Conditional Formatting to entire columns or rows. They are resource hungry and super volatile. Over time they will slow workbook performance down.

Instead consider applying them to a few more rows than you realistically anticipate using.