How to format time to duration of time in user input for dataset collection

@ahmadnasriya Thanks. I think it helps. It makes sense in my head what we are doing here. Taking Hours, converting it to seconds, Taking Minutes and converting those to seconds. Add all the seconds together to be able to sort, and then display it back as Hrs:Min:Sec.

What doesn’t make sense to me is where do I insert the code? I have one page where the user inputs the data into the fields and then they click Submit. As soon as they click submit, it takes them to another page that displays all the data that has been submitted by that user, the one they just submitted and previously submitted data all in one table. This is where we want them to be sorted by shortest duration to longest duration.

So where do I input the code you have referenced above? What pages do I put them in and do they have to be in a certain order on the page?

I would assume when the user clicks Submit, then that is where the system does the calculations behind the scenes prior to taking the user to the page where the data is displayed. Obviously it does this really fast.

Thanks again.