Highlighting cells with date/time greater than 29 minutes past the hour

[Demtro73]

I have a spreadsheet that posts times using a date and time format as listed below. I would like to use conditional formatting to highlight any cell with a time that is between 29 minutes past the hour and 59 minutes past the hour. Below is a 6 row sample with the cells I want highlighted automatically. For the purposes of this I am only interested in the minutes section of the time the date and hours is irrelevant.

I am reviewed several formulas but what I have found are generally to determine if the time falls between two different times using hours and minutes not just minutes.
Any help is appreciated, thank you

1/29/24 11:41 AM​

1/26/24 10:56 AM​

1/29/24 2:15 PM​

1/29/24 1:07 PM​

1/29/24 8:29 AM​

1/29/24 10:18 AM​

 

[Asbestos_Jen]

Try this in conditional formatting by formula:

Book1
	E	F	G
5		Minute
6	11:41:00 AM	41.00	TRUE
7	10:56:00 AM	56.00	TRUE
8	2:15:00 PM	15.00	FALSE
9	1:07:00 PM	7.00	FALSE
10	8:29:00 AM	29.00	FALSE
11	10:18:00 AM	18.00	FALSE
Sheet1

Cell Formulas
Range	Formula
F6:F11	F6	=MINUTE(E6)
G6:G11	G6	=AND(MINUTE(E6)>29,MINUTE(E6)<59)

 

[Cubist]

Are 29 and 59 minutes inclusive?
If so, try

Book2 (version 1).xlsb
	E	F	G
5		Minute
6	11:41:00 AM	41	TRUE
7	10:56:00 AM	56	TRUE
8	2:15:00 PM	15	FALSE
9	1:07:00 PM	7	FALSE
10	8:29:00 AM	29	TRUE
11	10:18:00 AM	18	FALSE
Sheet1

Cell Formulas
Range	Formula
F6:F11	F6	=MINUTE(E6)
G6:G11	G6	=MEDIAN(29,59,MINUTE(E6))=MINUTE(E6)

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you are after?

24 03 15.xlsm
	A
1
2	1/29/24 11:41 AM
3	1/26/24 10:56 AM
4	1/29/24 2:15 PM
5	1/29/24 1:07 PM
6	1/29/24 8:29 AM
7	1/29/24 10:18 AM
8	1/29/24 10:38 PM
CF Minutes

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A8	Expression	=MINUTE(A2)>=29	text	NO

 

[Demtro73]

Welcome to the MrExcel board!

Is this what you are after?

24 03 15.xlsm
	A
1
2	1/29/24 11:41 AM
3	1/26/24 10:56 AM
4	1/29/24 2:15 PM
5	1/29/24 1:07 PM
6	1/29/24 8:29 AM
7	1/29/24 10:18 AM
8	1/29/24 10:38 PM
CF Minutes

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A8	Expression	=MINUTE(A2)>=29	text	NO

Peter, that is what I am looking for, however I cannot seem to get that to work. I am using Excel as part of Office365. I used conditional formatting and added the formula you provided, but it did not work. My cells are formatted as Date/Text.

 

[Demtro73]

Peter, I was able to get it to work, thank you so much this is a great assist!

 

[Peter_SSs]

You're welcome. Glad you got it working. Thanks for letting us know.