[Forms] How could I calculate the time from 2 textboxes?

%3CLINGO-SUB%20id%3D%22lingo-sub-2597650%22%20slang%3D%22en-US%22%3E%5BForms%5D%20How%20could%20I%20calculate%20the%20time%20from%202%20textboxes%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597650%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20doing%20the%20overtime%20form%20on%20Microsoft%20forms%2C%20I%20have%204%3CSPAN%20class%3D%22ver%22%3E%20questions%3C%2FSPAN%3E%3A%3C%2FP%3E%3CP%3E1.%20I%20use%20the%20text-box%20for%20time%20start%20and%20end%20like%20the%20image%20below%2C%20how%20could%20it%20calculate%20the%20total%20hour%20instead%20of%20number%20'10.'%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22plawansai_0-1627894487221.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299825i517D9FA6C122FA5B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22plawansai_0-1627894487221.png%22%20alt%3D%22plawansai_0-1627894487221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20From%20the%20image%20above%20in%20the%20section%202%20of%20form%20is%20the%20first%20time%20OT%20of%20the%20month%2C%20second%20time%20OT%20require%20another%20section%2Fpage%20like%20this.%20Could%20the%20form%20ask%20like%20'Do%20you%20have%20another%20OT%3F'%3F%20If%20'%3CSPAN%20class%3D%22ver%22%3EYes'%20it%3C%2FSPAN%3E%20will%20next%20to%20page%20%3CSPAN%20class%3D%22ver%22%3E3%20with%3C%2FSPAN%3E%20same%20page%20form%2C%20however%2C%20if%20'No'%20it%20will%20finish%20the%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20How%20could%20auto%20run%20the%20document%20number%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4.%20How%20could%20link%20the%20type%20of%20OT%20and%20total%20hour%3F%20I%20would%20like%20to%20know%20which%20type%20is%20the%20most%20number%20of%20hours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2597650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECalculated%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForm%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOT%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOvertime%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I'm doing the overtime form on Microsoft forms, I have 4 questions:

1. I use the text-box for time start and end like the image below, how could it calculate the total hour instead of number '10.'?

 

plawansai_0-1627894487221.png

 

2. From the image above in the section 2 of form is the first time OT of the month, second time OT require another section/page like this. Could the form ask like 'Do you have another OT?'? If 'Yes' it will next to page 3 with same page form, however, if 'No' it will finish the form.

 

3. How could auto run the document number?

 

4. How could link the type of OT and total hour? I would like to know which type is the most number of hours.

 

Thank you very much.

0 Replies