How to create calculations in Input table?

  • JagtarTraders
    Asked on September 11, 2017 at 12:20 AM

    HI 

    I am looking to have the details from the employees of their everyday start time and finish time for both the shifts AM and PM and the hrs calculated for each shift and then also the total of the HRS from Mon to Sat in one place and for Sunday separate.  Hope this is bit more clear.

    Thanks

    Jotform Thread 1244011 Screenshot
  • Nik_C
    Replied on September 11, 2017 at 2:58 AM

    This is how you have to create conditions to make it work:

    How to create calculations in Input table? Image 1 Screenshot 30

    So for each pair of AM In and Am Out, PM In and PM Out you have to create the above condition. That will calculate like this:

    How to create calculations in Input table? Image 2 Screenshot 41

    If you need any further assistance please let us know.

    Thank you!

  • JagtarTraders
    Replied on September 11, 2017 at 7:43 AM
    HI
    please see the link below
    https://www.jotform.com/build/72532815793867
    everything is pretty much ok except that i need to put the time in actual
    time formate (ex 9:30 till 10:00 result .50hrs worked) and get it
    calculated to hrs worked with the output in decimal format.
    Please help me out
    *Thanks and Regards*
    *Harwinder *
    *Jagtar Traders*
    ...
  • amy
    Replied on September 11, 2017 at 10:15 AM

    While you are filling the time table would you please use dot "." instead of using colon ":"? By this way, the calculation functions can work properly. Please check my result:

    How to create calculations in Input table? Image 1 Screenshot 20