Hi

I am using the COUNTIF formula in a spreadsheet but i am struggling with a
part of it.

Column C has start times and column D has finish times. In row 1 from column
P to KR is 24 hour clock at 5 minute intervals. Column O has names.

This is my formula at present which works.

=COUNTIF($C3:$D3,P$1:KR$1)

This only highlights the start time and finish time. I also want to
highlight the time inbetween the start and finish time.

I hope i explained this well enough for you to help.