Lee_WalterAnswered on July 01, 2021 11:46 PM
I need to auto-fill time in a column while adding 15 mins. So when 1st row is entered with time in decimal (ex. 2.57) second and rest will auto-fill the entire column.
Ariel JotForm SupportAnswered on July 02, 2021 07:44 AM
I'm a little confused with your set there. You've said 15 minutes but in your example, the difference between your first number 2.57hrs (02:34:12) and the second number 3.12hrs (03:07:12) is 33 minutes.
15 minutes is 0.25 in decimals (15/60), so you only need to add 0.25 to the first number, and so on. I.e.:
Or, did I misunderstood your question? If that's the case, can you add more detail regarding your concern?
If you need further assistance, please feel free to contact us.
Lee_WalterAnswered on July 06, 2021 03:25 PM
Thank you for your quick response. Here is the link to the form - https://form.jotform.com/211815099962161
I would like to use "time" column to represent time information, but the table doesn't support time format as far as I know. So I would like to use decimal to represent time. In the first row user will enter actual time - 2.17 (same as 2:17). Then rest of the column will be filled automatically with each row adding 15 minutes to the previous number.
2.17 (user entered)
Jed_CAnswered on July 06, 2021 09:29 PM
It's possible, but you will create multiple conditions for each cells where you want to autofill the time. In my sample screencast below, I made 4 rows on Time column to fill when you put a value in the very first cell in Time column.
However, once you have reserved the cell with a condition, you can no longer use that cell with other condition as it will cause some conflict. If the user will always put the value on 1st cell in Time column, then that would be predictable with your condition. The condition won't work if don't know where cell the users will put the time.
If that's the case, it won't work with the input table, you'll have to create an individual field for that, then create your own custom calculation.
I hope that clarifies it, but let us know if you have any questions.
Lee_WalterAnswered on July 08, 2021 05:03 PM
Thank you for your quick response. However what I'm looking for is to adding 15 minutes to the time. But what you are doing is just adding .15 to the initial value. It doesn't work when minute value goes over 60. For example, if initial value is 2.57 then next number is 2.72 but what I want is 3.12; so it should round up to next hour. Please help!
Jed_CAnswered on July 08, 2021 08:34 PM
Please allow me some time to check on what formula is needed to increment the minutes. I'll let you know here once I have a solution.
Lee_WalterAnswered on July 15, 2021 03:42 PM
Jed_CAnswered on July 15, 2021 06:58 PM
Unfortunately, I'm unable to find a solution for this. Jotform doesn't have a math function that detects the number as a time. It only converts it in epoch time.
I've also tried it with a time property field, even the time field doesn't recognize the incremented number.