Others

How to Set Microsoft Lists Time Selection to 15-Minute Intervals

Olivia Miller Oct 1, 2026 868 views

Question details

The user needs to configure a date and time field in Microsoft Lists to allow time selections in 15-minute intervals.

How to Set Microsoft Lists Time Selection to 15-Minute Intervals

Product: Microsoft Lists
Device & OS: not provided
Scenario: Creating or modifying a list form where precise time entries are required for scheduling or logging.
Observed behavior: The default Date and time control in Microsoft Lists restricts the minute selection to 30-minute intervals.

Before you start

Ensure you have sufficient site permissions to customize Microsoft Lists forms and that your Microsoft 365 license includes access to Power Apps.

Solution 1Recommended

Customize the List Form using Power Apps

By integrating Microsoft Lists with Power Apps, you can replace the default time control with a custom dropdown that supports 15-minute increments.

Since the native Microsoft Lists interface does not support modifying the default 30-minute time picker, integrating with Power Apps is the most effective solution. This allows you to build a custom time selector using separate dropdowns for hours and minutes, giving you full control over the data entry process.

Open Power Apps from Microsoft Lists

Navigate to your Microsoft List, click on 'Integrate' in the top command bar, hover over 'Power Apps', and select 'Customize forms'.

Unlock the Date and Time Card

In the Power Apps studio, select your form, find the Data card containing your Date and Time field, go to the 'Advanced' tab on the right properties panel, and click 'Unlock to change properties'.

Replace the Minute Control

Delete the default minute dropdown control inside the card. Insert a new Dropdown control and set its 'Items' property to an array of your desired 15-minute increments, such as ["00", "15", "30", "45"].

Modify the Update Property

Select the entire Data card and modify its 'Update' property to combine the selected date, hour dropdown value, and your new minute dropdown value into a valid DateTime format.

Save and Publish to SharePoint

Click 'File', select 'Save', and then click 'Publish to SharePoint'. Return to your Microsoft List to verify that the customized form now allows 15-minute interval selections.

Customize the List Form using Power Apps

Using Standalone Apps: If you are building a standalone canvas app instead of customizing the list form directly, you will need to use the Patch() function to submit the combined DateTime value back to your Microsoft List.

Free Microsoft Office alternative

Looking for a Lightweight and Powerful Office Suite?

While you manage your lists and workflows online, you might also need a robust tool for your documents, spreadsheets, and presentations. WPS Office is a lightweight, fully compatible alternative to Microsoft Office that offers a familiar interface for free.

1. Download the Installer: Visit the official WPS Office website and download the appropriate installer for your Windows, Mac, or Linux device.
2. Install WPS Office: Run the downloaded setup file and follow the on-screen prompts to complete the installation in just a few minutes.
3. Open Your Documents: Launch WPS Office and instantly open, edit, or create your Word, Excel, and PowerPoint files with zero learning curve.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) file formats.Features a familiar, easy-to-use interface with a built-in tabbed workspace.Lightweight software that installs quickly and runs smoothly on older devices.Provides rich built-in PDF editing and conversion tools at no extra cost.

microsoft office alternative - wps office

Frequently Asked Questions

Can I change the time interval directly in Microsoft Lists without using Power Apps?

No, the native Date and time column settings in Microsoft Lists and SharePoint currently do not offer a built-in feature to change the interval from the default 30 minutes. Power Apps is required to make this customization.

Will customizing the form in Power Apps affect my existing list data?

No, customizing the form in Power Apps only modifies the data entry interface. Your existing list items and their previously saved time values will remain completely unaffected.

How can I revert to the default Microsoft Lists form if I no longer want the Power Apps customization?

To restore the default form, go to your List settings, click on 'Form settings', select 'Use the default SharePoint form', and click OK. You also have the option to delete the custom form permanently from this menu.

Office Quick Solutions