I need to auto-fill time in a column while adding 15 mins.

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.

1. 2.57

2. 3.12

3. 3.27

4. 3.42

etc.

Greetings,

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.:

1. 2.57
2. 2.82
3. 3.07
4. ...

Or, did I misunderstood your question? If that's the case, can you add more detail regarding your concern?

Please share the URL of the form you're working on for us to better assist you. You can also send us screenshots to better illustrate the issue.

Anyway, if you need to perform calculations on your form, you could either use the Form Calculation widget or Conditional Logic's Update/Calculate Field.

If you need further assistance, please feel free to contact us.

Ariel,

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.

Example -

2.17 (user entered)

2.32 (auto-filled)

2.47 (auto-filled)

3.02 (auto-filled)

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.

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!

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.

Any update?

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.