Microsoft Forms: Adding date AND time question to survey?

Anonymous
2020-07-29T03:13:34+00:00

Hello, 

I'm trying to create a survey that logs "observations" done every time it's submitted.  I see a field for the user to enter a date, but I don't see a "time" field to accompany it.  Any suggestions to incorporate time besides being a free text field?  Time needed would be hour and minute (no seconds).  Appreciate any help!

Microsoft 365 and Office | Microsoft Forms | For home

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-30T01:46:56+00:00

    Hi Chris,

    I'm sorry to inform you but this feature is not supported in MS forms. However, the function is available in MS forms Pro but there's an additional cost for it. You can see below link for further information about MS Forms Pro.

    https://docs.microsoft.com/en-us/forms-pro/purc...

    Hope this helps.

    Stay safe and Thank you :)

    Jennifer J.

    Was this answer helpful?

    30+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-07-29T17:42:48+00:00

    Hi Jennifer, 

    Please see attached screenshot.  I can have a question for "date," however there is no "time" of the day function.  Only work around I could see is putting a drop down with the number of hours in the day in one hour blocks, but looking to have hours and minutes as an option. 

    Thank you, 

    Chris

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-07-29T07:14:25+00:00

    Hello Jennifer,

    sorry I’m talking about in the survey itself in Forms, not in the data extract in excel.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  4. Anonymous
    2020-07-29T06:42:55+00:00

    Hi Chris,

    Good day!

    I see that you are using Ms Forms online.

    Well, please try below formulas to remove seconds on date format.

    1. This may help: (assuming your date is in A1)

    =A1-SECOND(A1)

    2.Or you may try thi =A1-TIME(0,0,SECOND(A1))

    Hope this helps you. :)

    * Note : Please mark as resolved if this helps you if not don't hesitate to ask if further assistance is needed.

    Stay safe & Thank you,

    Jennifer J.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2020-07-29T03:27:10+00:00

    Hi Chris,

    Good day!

    I'm Jennifer, Independent Advisor here and a Microsoft user like you. I'm happy to work with you on this issue. Let me see if I can help you with this.

    Are you using Ms forms Pro online or are you using other application?

    Hope this helps you. :)

    * Note : Please mark as resolved if this helps you if not don't hesitate to ask if further assistance is needed.

    Stay safe & Thank you,
    Jennifer J.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments