+1Hello.
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.
Thanks, JB
+1Hey. Thanks for the help. I followed the steps identified and I am getting the following error.
Here is the setup of the following calculations.
+1+1Hello.
I was actually able to figure it out in one calculated value without having to do three separate calculations.
|
(dateDiffHours(IntDowntimeActivitiesStart,IntDowntimeActivitiesStop)) + ":" + (dateDiffMinutes(IntDowntimeActivitiesStart,IntDowntimeActivitiesStop)-60*(dateDiffHours(IntDowntimeActivitiesStart,IntDowntimeActivitiesStop)))
|
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.