Conditional formatting between times (2)

[JDK1998]

I am building a scheduling table with start and end times ... which then populate a "timeline" across the business day.
The business day is a series of columns in 15 minute increments starting at 05:00:00 AM to 10:00:00 PM.
The timeline fills the cells between the start and end times entered.
I found a good post to create the timelines using conditional formatting.
Mr. Excel - Conditional formatting between times

I am using this formula:
=AND(MOD(I$30,1)>=$E31,MOD(I$30,1)<=$F31)

Where I$30 is the first cell of the business day (05:00:00 AM)
$E31 is the start time, $F31 is the end time

However, times after 10:00:00 AM are not applying the conditional formatting to the corresponding first cell (start time) of the timeline (start time).
Visually, it appears that the timeline actually starts 15 minutes later than the entered start time.

Any ideas on how to fix?
Thanks
JDK

 

[JamesCanale]

It looks like rounding errors. Look at this demonstration:

Book2
	A	B	C
1	10
2	24
3	0.416666667	10:00:00 AM	0.416666667
4
5		=	FALSE
6		>	FALSE
7		<	TRUE
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A1/A2
B3	B3	=40626+A3
C3	C3	=MOD(B3,1)
C5	C5	=C3=A3
C6	C6	=C3>A3
C7	C7	=C3<A3

maybe round all of your numbers to the nearest thousandth or something to make sure this weirdness doesn't happen.

 

[awoohaw]

Does this work for you:

Book1
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK
30	Start (hh:mm)	Finish (hh:mm)		05:00	05:15	05:30	05:45	06:00	06:15	06:30	06:45	07:00	07:15	07:30	07:45	08:00	08:15	08:30	08:45	09:00	09:15	09:30	09:45	10:00	10:15	10:30	10:45	11:00	11:15	11:30	11:45	12:00	12:15	12:30	12:45	13:00	13:15	13:30	13:45	14:00	14:15	14:30	14:45	15:00	15:15	15:30	15:45	16:00	16:15	16:30	16:45	17:00	17:15	17:30	17:45	18:00	18:15	18:30	18:45
31	08:00	09:00
32	08:45	09:00
33	09:00	09:30
34	10:00	12:00
35	11:30	12:45
36	12:00	13:10
Sheet1

Cell Formulas
Range	Formula
H30	H30	=TIME(5,0,0)
I30:BK30	I30	=H30+ (15/(60*24))
E31	E31	=TIME(8,0,0)
F31:F32,E33	F31	=TIME(9,0,0)
E32	E32	=TIME(8,45,0)
F33	F33	=TIME(9,30,0)
E34	E34	=TIME(10,0,0)
F34,E36	F34	=TIME(12,0,0)
E35	E35	=TIME(11,30,0)
F35	F35	=TIME(12,45,0)
F36	F36	=TIME(13,10,0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H31:BW36	Expression	=AND($E31<=H$30,$F31>H$30)	text	NO

 

[JDK1998]

Thank you both for your suggestions.
awoohaw,
I applied the time formatting you indicated and that resolved the start time formatting.
I then used your suggested formula and that resolved the end time formatting.
All is good and working as desired.
Thanks and all the best.
JDK

 

[awoohaw]

I am pleased you found a solution!
Best Wishes!