Calculating two time/dates from Form and Creation date

Occasional Visitor

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. 

0 Replies