Data Validation

Resolved · Low Priority · Version 365

Tue 8 Aug 2023, 16:07 Delegate Ryan said...

Ryan has attended:
Excel Advanced course

Data Validation

Is there a way through data validation that we can only accept time formats of hh:mm rather than hh:mm:ss?

Tue 8 Aug 2023, 17:01 Trainer Jens said...

RE: 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips