Manual Input of a Time Duration Form Element

  • jaronnevi
    Asked on May 25, 2020 at 11:01 PM

    I'm trying to make an element that allows one to input the duration (time it takes to complete a task) With hours, minutes and seconds fields. I created a configurable list widget which is perfect for the one submitting the form but when I export an excel log of the submissions that field shows as: Hours:0, Minutes:30, Seconds:0. Is there a way to have it show in the excel sheet as hh:mm:ss automatically? Otherwise I will have to do this manually.

    Jotform Thread 2345823 Screenshot
  • roneet
    Replied on May 25, 2020 at 11:40 PM

    You may consider using a Fixed Format widget to let the user enter the time in the time format with seconds.

    https://widgets.jotform.com/widget/fixed_format

    155974091105062019 180600 Screenshot 10

    Let us know how it goes.

    Thanks.

  • jaronnevi
    Replied on May 26, 2020 at 11:52 AM

     roneet,


    This worked out perfectly. Thank you so much man.

  • jaronnevi
    Replied on May 26, 2020 at 12:30 PM

    roneet,


    One more question about this. How can you require the user to fill each field with 2 characters? i.e. hh=01 not hh=1

  • Anita_K
    Replied on May 26, 2020 at 1:39 PM

    Hi there,

    you may use underscores to represent characters.

    So if you set the widget to __/__/__/ it will limit each box to two characters.

    Manual Input of a Time Duration Form Element Image 1 Screenshot 20

    Please give it a go and let us know if you're happy with the result.

  • jaronnevi
    Replied on May 26, 2020 at 1:52 PM

    That didn't work. It does limit each field to 2 characters but doesn't enforce the entry of 2 characters. So you can just enter 1 and it will accept it. Here is what shows when I pull the excel. I need it to be more like 01:02:031590515548Annotation 2020 05 26 135120 Screenshot 10

  • Kevin Support Team Lead
    Replied on May 26, 2020 at 3:36 PM

    It seems like indeed the widget limits the entry to 2 characters as a max entry, but it allows submissions with one character only. 

    I would recommend you to try using a short text entry field instead and set up a mask, here is how:

    15905217682020 05 26 13h29 26 Screenshot 10

    Here's an example of the result: https://form.jotform.com/201465947341053 

    I hope this helps.