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

  • Profile Image
    jorgenev
    Asked on March 21, 2017 at 05: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?
  • Profile Image
    Nik_C
    Answered on March 21, 2017 at 05:30 PM

    You can use the input field:

    You can add more columns/rows if needed.

    Hope that helps.

    If you need any further assistance please let us know.

    Thank you!

  • Profile Image
    jorgenev
    Answered on March 21, 2017 at 05:37 PM

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

  • Profile Image
    jorgenev
    Answered on March 21, 2017 at 05: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?

  • Profile Image
    Ian
    Answered 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.