Utilising time in a drop down list to show start and finish time

Good afternoon

Sorry if this is an easy fix but i can't get my head around it.

Basically I have a very simple spreadsheet to be filled in by fairly computer illiterate people and want to produce drop down options for each column to avoid the operators having to type the information in. I have 5 columns
shift, time , Location, finished, comments/ delays

Obviously I have completed the list for shift, location & comments but I am trying to work out how to create a drop down list that would enable the operator to choose the correct time without having to trawl through a full list of every minute option on a 24 hour clock, sorry the operation runs 24 hours.

Is it possible to be able to drop down the list showing the available times or do i need to split the column into 2 and have hours and minutes seperate? which is what I'm also trying to avoid? Cant use auto fill in for exact point the cell is clicked as the sheet is not always filled in real time.

Hopefully there is a solution however if not i can feel some computer training coming on.

Thank you in advance

Do you actually need the exact minute, can't you have it rounded to 5 minutes or similar?

Presumably you are using Data Validation. Have you got a dummy workbook that you can attach?

hI

I think the quickest way for the user to enter date is pressing Ctrl + ; (the button right of the L) and for the Time, Ctrl+SHIFT+;
Now for the solution Validation List, I suggest the following.

Write to a cell that does not need =NOW(). Make the format that you need.

After do- Validation-list, in the cell that you need, allowing only data from that cell.

The trouble is that before the user choose from the list,should have done refresh of time, hitting anything in any cell wants.

Regards