Forum Discussion
Forms: Time input question
In Office 365 Forms, I am attempting to create an event request form. I do not appear to be able to add a question for TIME of Day. I see a template for DATE but not TIME. In Google Forms "include...
William Mattison I found this in the feedback site, hopefully voting for adding times might raise it's priority
https://feedbackportal.microsoft.com/feedback/idea/caf5e69c-d01c-ec11-b6e7-0022481f8eda
hi, I dont know if someone has suggested this but try using military time and asking the person doing the form to use this format hh%MM when submitting their response (ex 10%00 or 15%00 ) then when you download the responses select your time inputs and replace the Percent sign with colon and it should format the entry as time. if you already have entries as 10:00 simply replace the : with % then switch the back and it should format the entries.
- How is that a solution though if you receive a few hundred per day?
Why not just create a date time object? This has been going on for 3 and a half years now!
I just get my users to input 24 hour time stile without the colon. Works ok except from 0000 to 0959 (Drops the leading zero).