Data Validation

Hi Ryan,

Thank you for the forum question and thee nice feedback.

Select the range. Click Data Validation Allow select Custom and type the formula below.


=A2=TEXT(A2,"hh:mm")+0

Here I use A2 but you will need to change the cell references to the first cell in your selected range.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector