How Can I Create a Timesheet That Calculates The Time Worked?

  • Profile Image
    Kassimartin
    Asked on February 09, 2018 at 04:34 PM

    Hello,

    Our employees currently use paper time cards that they input the time in and time out for each day worked during a two week pay period. I am wanting to create a form where they can input their time for the pay period; however, I need the form to calculate the total amount of time worked. I do not want the employees to enter their total time. I want to see the time they are clocking in and the time they are clocking out. Is there a good way to do this. 

  • Profile Image
    Kevin_G
    Answered on February 09, 2018 at 07:33 PM

    I think this may be possible to achieve using a multiple pages form and the save and continue later feature. 

    It's not possible to have the data captured and perform the calculations collecting all the submissions so you will need to do it all in one single submission per person.

    Basically, the guides you will need to use can be found here: 

    - These guides will help you performing the calculations on your form: 

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    https://www.jotform.com/help/443-Mastering-Date-and-Time-Calculation

    - Once you have created the template for recording the time worked and the needed info you will need to clone the fields and split the form into multiple pages, this guide will help you managing multiple fields at the same time:

    https://www.jotform.com/help/242-How-to-Manage-Multiple-Fields  

    - This guide will help you creating a multiple pages form, I think you may create basically one page per work day where the users will be recording their time: 

    https://www.jotform.com/help/119-How-to-Create-Multi-Page-Forms

    - This guide will help you allowing your users to save their work and continue later one, please note that the info is saved on our servers up to 90 days: 

    https://www.jotform.com/help/97-How-to-Save-Forms-and-Continue-Later 

    Here's an example about how that may work, see how the form calculates the day total hours worked: https://form.jotform.com/80396958320969 

    An important thing to have in mind is that the time fields need to be on 24 hours format: 

    15182227831.png

    Feel free to clone my form and see what I did on there: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    If you have questions, let us know. 

  • Profile Image
    Ryan_Briones
    Answered on February 09, 2018 at 07:42 PM

    Currently, you can’t create a form that will calculate both the clock-in/clock-out and the total number of hours a week. It may not be obvious, but the process is complicated and is somewhat beyond the capability of the form.

    You can, however, create a simpler timesheet that will allow your employees to manually enter their total time and use the Form Calculation Widget to calculate the total hours.

    Here's a guide to help you setup a Form Calculation Widget. Feel free to write back to us if you have more questions.