Macro - add a new column cell value based on a column's cell value (time)

[Restricted]

Amount	Date & Time	Title	Comments	addNewCol
2000	9/10/2017 10:15	A	C
3331	9/10/2017 14:20	B	D
1450	9/10/2017 14:45	E	F	X
2441	9/10/2017 16:24	G	H	X

<tbody>
</tbody>

Date & Time column is in this custom format:

d/mm/yyyy h:mm

• Data is entered into the cell like so: 9/10/2017 5:00:00 PM
• and appears like so, as per custom format: 9/10/2017 17:00

There are batches of date/times, each split into 3 hour intervals, each batch separated by a blank row, as shown above,
I need a macro that searches for a particular time range (i.e. 2:40PM - 4:39PM) in the 'Date & Time' column, and if it falls within that range, it adds an 'X' in a new column (the next available empty column I suppose) for that particular row matching the criteria.

It would be ideal to have a pop up that asks for the time range I'm interested in, but I'm happy to edit and run the macro manually to suit the criteria I require.

Any ideas?

 

[Restricted]

bump