Others

Can Microsoft Forms Capture Date and Time in 24-Hour Format?

John Wilson Sep 28, 2026 869 views

Question details

The user wants to know if there is a way to manually capture both the date and time in a 24-hour format (DD/MM/YYYY, HH:MM) within a single Microsoft Forms question.

Can Microsoft Forms Capture Date and Time in 24-Hour Format?

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a survey, registration form, or questionnaire where respondents must input a specific date alongside a 24-hour time format.
Observed behavior: Microsoft Forms does not currently offer a native combined date-and-time question type that supports custom DD/MM/YYYY and HH:MM 24-hour input.

Before you start

Determine how you plan to process the collected data, as you will need to rely on separate form fields or external tools to handle 24-hour time inputs efficiently.

Solution 1Recommended

Use Separate Questions for Date and Time

Since a combined date-time field is unavailable, splitting the input into two separate questions is the simplest and most effective workaround for respondents.

By utilizing a standard Date question and a separate Text question for the time, you can guide users to input the information in your desired format.

Add a Date question

Open your form in Microsoft Forms, click 'Add new', and select the 'Date' option. Title it appropriately (e.g., 'Select the Date').

Add a Text question for the time

Click 'Add new' again and select 'Text'. Title this question 'Enter the Time'.

Specify the 24-hour format in the subtitle

Click the three dots (More settings) on the Text question, select 'Subtitle', and add a clear instruction like 'Please use 24-hour format (HH:MM), e.g., 14:30'.

Use Separate Questions for Date and Time

Formatting Limitations: While you can ask users to enter the time in a 24-hour format, Microsoft Forms cannot strictly validate text to ensure an HH:MM structure is followed.

Solution 2

Combine and Format Responses Using Power Automate

If you require the final output to be strictly formatted as a combined DD/MM/YYYY HH:MM string in a database or email, you can use Power Automate to transform the data after submission.

Free Microsoft Office alternative

Analyze and Format Survey Data Effortlessly with WPS Office

Since Microsoft Forms lacks custom combined date and time entries, you will often need to manipulate the exported data yourself. WPS Office is a powerful, highly compatible alternative to Microsoft Office that makes formatting, combining, and analyzing downloaded survey data simple.

1. Export your responses: From the Microsoft Forms 'Responses' tab, click 'Open in Excel' to download your raw data.
2. Open with WPS Spreadsheet: Launch WPS Office and open your newly downloaded .xlsx file.
3. Format your data: Select the relevant columns, right-click to choose 'Format Cells', and apply a custom 24-hour date and time format.

100% compatible with Microsoft Excel (.xlsx) formats downloaded directly from Forms.Easily combine separate date and time columns using powerful spreadsheet formulas.Apply custom DD/MM/YYYY HH:MM 24-hour formatting seamlessly to your cells.Lightweight, fast, and completely free to use without subscription limitations.

Frequently Asked Questions

Does Dynamics 365 Customer Voice support 24-hour date and time formats?

No. The same limitation found in Microsoft Forms applies to Dynamics 365 Customer Voice, which was formerly known as Microsoft Forms Pro. You will need to use similar workarounds.

Can I force a specific time format in a Microsoft Forms text field?

Microsoft Forms offers basic numerical restrictions, but you cannot enforce a strict HH:MM time format using regular expressions natively. It is recommended to use the subtitle feature to provide an example for your respondents.

Will Microsoft add a 24-hour date and time feature in the future?

Microsoft regularly updates its products based on user feedback. You can suggest this feature or vote for existing requests on the official Microsoft Feedback Portal to encourage developers to add custom date-time controls.

Office Quick Solutions