I have a form with multiple sections that have separate Start and Stop times. I want to add a Calculated Value with a formula that displays HH:MM for the time between the Start and Stop dates/times. I can figure out HHs or MMs separate but not as HH:MM.
Solved! Go to Solution.
I was able to create a formula to calculate the difference in time between to dates/times and display in the format HH:MM.
What I did is the following:
hours + ":" + minutes
I've attached two screenshots showing the end result:
I hope this helps!
Hey. Thanks for the help. I followed the steps identified and I am getting the following error.
Here is the setup of the following calculations.