Excel for Microsoft 365 on Windows does not include a built-in pop-up clock for choosing a time in a worksheet cell. The closest no-code option is a drop-down list made with Data Validation; use a time restriction when you only need to limit what people can type, or an add-in or custom VBA form when you need a clock-style interface.
What Excel means by a time picker
A time picker is an interface that lets someone select a time rather than type it. In a typical web form, it may look like a small clock or a list of available times. Excel worksheet cells work differently: they accept values and can apply validation rules, but a normal cell does not open a clock control when selected.
This distinction matters because search results and older tutorials sometimes use “time picker” loosely. They may show a date-and-time control from an older version of Excel, a third-party add-in, or a custom form. Those are not the same as a standard feature available in every current Excel workbook.
Excel does understand time values. It stores a time as a fraction of a 24-hour day: midnight is zero, noon is one-half, and 6 p.m. is three-quarters. A cell’s number format determines whether that value appears as 6:00 PM, 18:00, or another display. Formatting changes how a value looks; it does not add a picker.
Best built-in option: a drop-down list
For a predictable set of choices—such as appointment slots every 30 minutes—a Data Validation list is usually the simplest substitute. The user selects a cell, opens its arrow, and picks one of the listed times. It is a list picker, not a clock face, but it prevents inconsistent entries such as 9.30, 9:30am, and 09:30 being entered as different text formats.
- Enter the permitted times in a spare range on the same worksheet, for example H2:H49. Enter them as real Excel times, not text, and format the range as h:mm AM/PM or hh:mm.
- Select the cell or cells where users should choose a time.
- On the ribbon, select Data > Data Validation. In the Settings tab, set Allow to List.
- Set Source to
=$H$2:$H$49, make sure In-cell dropdown is selected, and choose OK. - Format the entry cells with the same time format as the list so the chosen value is easy to read.
Keep the source range on the same worksheet for the most straightforward setup. To keep the list on another sheet, define a name for the range with Formulas > Define Name, then use that name as the validation source. A list can also be placed in a hidden helper column, but document where it is if another person will maintain the workbook. Data Validation is an input aid, not strong security: users can paste values into cells in ways that bypass validation.
Generate a list of time slots
You do not have to type every slot. Excel 2021 and Microsoft 365 support SEQUENCE, which can create regularly spaced time values. With cell A2 empty and A2:A49 clear for the results, enter this formula in A2:
=SEQUENCE(48,1,0,1/48)
The formula returns 48 values, starting at midnight and increasing by 1/48 of a day—30 minutes—so the final value is 11:30 PM. Format A2:A49 as h:mm AM/PM to display the results clearly. Use the generated range as the source range for the validation list, or copy and paste values if you want a fixed list that will not recalculate. For 15-minute slots, the equivalent list has 96 entries and a step of 1/96; adjust the row count and step together.
SEQUENCE produces numbers that Excel treats as times when displayed with a time format. The formula does not itself create a drop-down, choose an appointment duration, or block conflicts. If your workbook must work in versions earlier than Excel 2021, create the list by entering a starting time and filling a sequence, or type the available options directly.
Restrict entries without offering a picker
If people can type any time within a permitted window, a time validation rule may be more convenient than a long list. Select the input cells, choose Data > Data Validation, set Allow to Time, choose a comparison such as between, and enter the start and end times. For example, a window from 9:00 AM to 5:00 PM accepts times within that range, but it does not show a menu of choices.
You can also customize the Input Message and Error Alert in the Data Validation dialog. An input message can tell users to enter a time between the opening and closing hours. An error alert can explain why a value was rejected. Choose the alert style deliberately: a Stop alert blocks an invalid entry, while less restrictive alert styles can allow a user to proceed after a warning.
Validation is useful for basic data entry, but it cannot ensure that every value was entered through the intended interface. If the workbook is used for scheduling, consider adding a separate check for overlapping appointments, unavailable dates, or other business rules. A time-only restriction also cannot determine whether a particular staff member or room is actually free.
Make time values display correctly
Excel can display the same underlying time in several ways. Select the cells and use Home > Number Format, or open Format Cells with Ctrl+1 on Windows and choose a time format. Common choices include h:mm AM/PM for a 12-hour clock and hh:mm for a 24-hour clock. On Mac, use Command+1 to open Format Cells. A number format affects appearance, not the stored time.
A frequent problem is entering a value that looks like a time but is actually text. Text generally will not behave like a numeric time in calculations or sorting. If a time remains left-aligned or does not change when you apply a time format, check how it was entered and whether the cell is formatted as Text. Re-entering the value after changing the format, or converting imported text, may be needed.
Midnight and elapsed time deserve special attention. A time-of-day value wraps around at midnight, so subtracting 11:00 PM from 1:00 AM directly can produce a negative result. Also, a normal clock format can make a duration of 27 hours appear as 3:00. For elapsed hours, use a duration format such as [h]:mm so hours above 24 remain visible. A picker or drop-down does not resolve these calculation and display choices for you.
What happened to the old Date and Time Picker control?
Some older Excel instructions refer to a Microsoft Date and Time Picker ActiveX control, often associated with the legacy MSCOMCT2.OCX component. It was not a universal worksheet feature, and it is not a dependable option for a modern workbook. Availability depends on legacy components and system configuration; in particular, many older ActiveX controls are not available in 64-bit Office installations.
Even when an old control can be made to work on a particular Windows computer, it may not travel well to other computers. A recipient may not have the component installed, may use a different Office architecture, or may open the workbook in Excel for the web or on a Mac. ActiveX controls are Windows-specific, and Excel for the web does not run worksheet ActiveX controls or VBA macros. For a workbook shared widely, a validation list is usually more portable.
The Developer tab can expose controls and tools for specialized Windows workbooks, but finding an ActiveX control in a tutorial does not mean it is supported in every Microsoft 365 installation. Avoid building a shared process around a legacy control unless you can control and verify the computers, Office versions, and security settings involved.
When an add-in or custom form makes sense
A third-party add-in may provide a calendar-and-time interface or another selection widget. Before installing one, check who publishes it, what data it can access, whether it works with your Excel version, and whether it supports Windows, Mac, or the web. In a workplace, confirm that the add-in is permitted by your organization. Features, support, and pricing vary by publisher, so there is no single standard cost or compatibility guarantee.
A VBA UserForm can be designed to open when a user selects a cell and present buttons, lists, or other controls. This can produce a more tailored experience, such as offering only the shift start times relevant to a selected date. However, it takes VBA knowledge to build and maintain, requires a macro-enabled workbook, and may be blocked by macro security settings. Macros also do not run in Excel for the web, and VBA controls can behave differently across Windows and Mac.
Use a custom interface only when the benefit justifies the maintenance burden. For a small list of appointment times, data validation is simpler to audit and share. For a workbook used by many people or across devices, a web form or scheduling system may be a better fit than trying to make a worksheet behave like a dedicated booking application.
Choose the right approach
The right option depends on what the person entering data needs to do, not just on whether a clock graphic is available. Consider these practical differences:
- Fixed options: Use a validation drop-down when users must choose from defined slots, such as 8:00, 8:30, or 9:00.
- Flexible times within limits: Use Allow: Time validation when users may enter any time in a permitted range.
- Guided, specialized entry: Consider a VBA form or a vetted add-in if the interface must respond to other selections or enforce more complex rules.
- Cross-platform sharing: Prefer ordinary cells, formats, and validation lists over ActiveX or macro-dependent controls.
- Bookings with availability and conflicts: Use a scheduling tool or a carefully designed workbook with separate conflict checks; a picker alone does not reserve a slot.
For a simple internal log, a drop-down is often the best balance of speed and reliability. For a staff rota, the key requirement may be preventing invalid shifts rather than making entry look like a clock. For customer bookings, a spreadsheet picker cannot provide the live availability, confirmations, and concurrency handling normally expected from a booking service.
Excel for Mac and the web
Data Validation lists and standard time formatting are more portable than legacy controls, though the exact ribbon layout can differ between Windows, Mac, and browser versions. In Excel for Mac, look for Data Validation on the Data tab; keyboard shortcuts also differ, as noted above for Format Cells. Check the dialog labels in the installed version if a menu item is arranged differently.
Excel for the web can display and use many worksheet data-validation drop-downs, making a basic list a more practical shared option than VBA. It does not run VBA macros or ActiveX controls. If a workbook depends on a custom picker, users may need the desktop version and the required platform; confirm that requirement before distributing the file. Test the workbook in the actual versions and devices your users rely on.
Frequently Asked Questions
Does Excel have a built-in time picker?
No. A standard Excel worksheet cell does not open a pop-up clock. You can use a Data Validation list as a simple picker, restrict acceptable times with validation, or use a compatible add-in or custom form for a more visual interface.
How do I add a time drop-down in Excel?
Put valid time values in a range, select the input cell, and choose Data > Data Validation. Set Allow to List, point Source to the range, and ensure In-cell dropdown is selected. Format both the list and input cells as times.
Can I make the drop-down show 15-minute intervals?
Yes. Create 96 time values from midnight through 11:45 PM, spaced 15 minutes apart, then use that range as the validation source. In Microsoft 365 or Excel 2021, SEQUENCE can generate the values; format them as times before using the list.
Why does my selected time show as a decimal?
Excel stores time as a fraction of a day, so a cell with General formatting may display a decimal. Apply a time format such as h:mm AM/PM or hh:mm. The underlying value is still a numeric time.
Will a time picker work in Excel for the web?
A normal worksheet validation list is the most portable approach and can be used in supported web workflows. VBA and ActiveX-based pickers do not run in Excel for the web, so do not rely on them for browser-only users.
Related
- Conditional Formatting: Use More Than One Rule in Excel
- table() in RStudio: How It Counts and Displays Data
- Data Validation and Reconciliation in Excel Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add Different Page Numbers in Word by SectionTo add different page numbers in Word, divide the document into sections, unlink the header or footer where…
- Excel Text Join Range: How to Combine Cell ValuesTo join the text in an Excel range, use TEXTJOIN: with values in A2:A5, for example, enter =TEXTJOIN(",…
- Excel Named Range Shortcut: Create, Edit, and Use NamesIn Excel for Microsoft 365 on Windows, press Ctrl+F3 to open Name Manager and manage named ranges. To…
- Mail Merge in Word From Excel: Step-by-Step GuideTo mail merge in Word from an Excel file, prepare a clean list with one recipient per row,…
- How to Check Double Spacing in WordTo check whether text is double-spaced in Word, place the cursor in a paragraph or select the paragraphs,…
- How to Hide Columns in Excel for the Web: Steps & TipsTo hide columns in Excel for the web, select the column letter or letters, right-click the selection, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.