Conditional Formatting between times

[rfletcher35]

I have date and on column E I have dates and times. I am wanting to conditional format on the times in this column, specifically between two times?

Can this be done?

So say if a time is between 08:00 and 12:00 then the column will turn blue, and or give me a figure in another column of the number it filters?

Please help

Fletch

 

[steve the fish]

Use a CF formula such as:

=AND(MOD($A1,1)>=8/24,MOD($A1,1)<=12/24)

Where the 8 and 12 in the formula are the times.

 

[rfletcher35]

Perfect thanks.

Fletch