Calculating two time/dates from Form and Creation date

%3CLINGO-SUB%20id%3D%22lingo-sub-2175512%22%20slang%3D%22en-US%22%3ECalculating%20two%20time%2Fdates%20from%20Form%20and%20Creation%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2175512%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20form%20set%20up%20that%20asks%20for%20the%20date%20and%20time.%3CBR%20%2F%3ESince%20I%20have%20the%20basic%20version%20of%20Microsoft%20forms%2C%20I%20cannot%20enter%20in%20a%20time.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I've%20done%20is%20created%20three%20drop-down%20questions%20in%20the%20form.%3CBR%20%2F%3EHour%3A%201-12%2C%20Minute%3A%200-59%2C%20Time%20of%20Day%3A%20AM%20or%20PM.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20data%20then%20is%20moved%20to%20a%20SharePoint%20List%20that%20also%20displays%20the%20%22Created%22%20date%20and%20time.%3CBR%20%2F%3EI%20want%20to%20string%20my%20data%20across%20so%20I%20can%20calculate%20the%20time%20difference%20between%20the%20date%20from%20the%20form%20and%20from%20the%20created%20date.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can%20use%20calculated%20column%20times%20to%20string%20the%20information%20from%20the%20form%20just%20fine.%26nbsp%3B%3CBR%20%2F%3EHowever%2C%20the%20date%20will%20display%20in%20serial%20format.%20I%20don't%20mind%20that%20it%20does%20but%20I%20still%20cannot%20figure%20out%20how%20to%20calculate%20the%20difference.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2175512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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