But what if we need to include the date- or the hours in and hours out? Is there a way to add more columns to this tool while maintaining the summatio

  • jorgenev
    Asked on March 21, 2017 at 5:07 PM
    But what if we need to include the date- or the hours in and hours out? Is there a way to add more columns to this tool while maintaining the summation in the final column?
  • Nik_C
    Replied on March 21, 2017 at 5:30 PM

    You can use the input field:

    But what if we need to include the date or the hours in and hours out? Is there a way to add more columns to this tool while maintaining the summatio Image 1 Screenshot 20

    You can add more columns/rows if needed.

    Hope that helps.

    If you need any further assistance please let us know.

    Thank you!

  • jorgenev
    Replied on March 21, 2017 at 5:37 PM

    Ok but then how do you use summation with this tool?

  • jorgenev
    Replied on March 21, 2017 at 5:42 PM

    It looks like there is a calculation function if you assign cells to a value as if you were using this for a questionnaire not a time sheet. 

     

    Is there a way to input time in, time out and have the next column calculate the number of hours, then a column for unpaid meal time and then the final column to make a total paid hours?

  • Ian
    Replied on March 21, 2017 at 10:02 PM

    I found a discussion on time timesheet based form and its calculation at https://www.jotform.com/answers/424576-Advanced-Time-Field-with-applied-time-based-calculations-for-timesheets

    Please go through that and let us know if that helped.