Mar 01 2021 12:30 PM - edited Mar 01 2021 12:31 PM
I have a form set up that asks for the date and time.
Since I have the basic version of Microsoft forms, I cannot enter in a time.
What I've done is created three drop-down questions in the form.
Hour: 1-12, Minute: 0-59, Time of Day: AM or PM.
The data then is moved to a SharePoint List that also displays the "Created" date and time.
I want to string my data across so I can calculate the time difference between the date from the form and from the created date.
I attached an image to help understand.
I can use calculated column times to string the information from the form just fine.
However, the date will display in serial format. I don't mind that it does but I still cannot figure out how to calculate the difference.