Date and time

[wjb1976]

Hi

I would like to create a timesheet for my operatives to use but would like for them to select time in 5 minute intervals through data valadation is this possible and could also be done by selecting the date in the same way?

[alansidman]

Here is one solution for ensuring dates are entered correctly:

http://www.fontstuff.com/excel/exltut03.htm

For times you could create through data validation a combo box with all the times in 5 minute intervals. However, that would require 288 entries if you wanted to make it available for a 24 hour period. I'm not sure that is the best way. Hopefully, others will have a better solution for you on that perspective.