Can I display the total of hours/time when between an start and end time?

  • Profile Image
    Asked on January 09, 2014 at 11:20 AM

    Im looking to try and get a timesheet submission form for events that may pass midnight 

    i would like a user to input date and start time for event-1 start

    i would like a user to input date and end time for event-1 end

    and have this email report the date start and end time with total hours for this event


    simple and clean with 7 areas to input dates and times please see picture .. not sure if total hours could display ion the form but not really a huge deal, just need it to report out..  any help in this matter would be great thanks  all jot form users ! 




  • Profile Image
    Answered on January 09, 2014 at 02:17 PM

    What you need can be accomplished by using our Time tool. Using that feature you will be able to enable the time Range property so that you can ask for the Start and End time.

    Then to enable the function to show the total of time/hours just follow this steps:

    1. right click on the Time field and click on Show properties.

    2. Then switch to Yes the option Time Range Duration.

    And that's it I hope this helps.  Please inform us if you need further assistance with this inquiry.


  • Profile Image
    Answered on January 09, 2014 at 02:25 PM

    EliezerN, thank for your responce, while this option is very usefull within a 24 hr period it will NOT work for what i need.


    guy "A' starts an event "his shift"  09/01/2014 @ 8:00pm until 10/01/20014 @8:15am


    thi si what im looking for ...


    the option you have shown is only within the same 24 day 

  • Profile Image
    Answered on January 09, 2014 at 04:39 PM

    Unfortunately, we do not have such option available. I have submitted a feature request ticket to our Development Team in order to add it, but I can not provide any ETA on it.

    We will let you know once we have any updates.

    Note, it might be possible to manually write a Javascript code to do these calculations with the form source. However, it can not be integrated directly into the editor, so that you will need a custom script and host the form by yourself.

  • Profile Image
    Answered on January 13, 2014 at 10:25 PM

    thank you, im surprised that there is not a weekly hours submission form ( like a truck drivers log book ) where it passes through the midnight