Time calculation - basic time sheet calculation. Time card

  • orisons.qa
    Asked on February 10, 2021 at 1:51 PM

    i have a problem with my form, please import this link for a better view and understanding.

    the form works perfectly fine for Monday it calculates the difference accurately, i tried to use the same conditions , text boxes and logic for the other days i.e TUESDAY but it just does not work.

    https://www.jotform.com/build/210404303329442/settings/conditions/22#preview

    also the conditions used for calculation the difference in time the variables selected are unknown ( the results table which has clock in , clock out and something called total hours less lunch)


    please help
    Thanks in advance

    Page URL: https://www.jotform.com/build/210404303329442/settings/conditions/22#preview
  • Hiba
    Replied on February 10, 2021 at 1:56 PM

    Facing same issue please help

  • Alexander_G
    Replied on February 10, 2021 at 5:39 PM

    Hello!

    Thank you for contacting us.


    Please, allow us some time to give a response on it.

    Currently, I am investigating your form right now.


    Thanks,

    Alex

  • Alexander_G
    Replied on February 10, 2021 at 6:02 PM

    Hello,

    Thanks for the patience.


    You can use date elements + calculations.

    It might be more efficient and require fewer calculations.

    Demo form: https://form.jotform.com/210406389598971

    Guide:Mastering-date-and-time-calculation


    Is it suitable for you?

    Thanks,

    Alex


    Related templates

  • princess5510
    Replied on February 11, 2021 at 1:45 AM

    Alex,

    My company wants me to enter the time by a drop down column, since it will be hard and time consuming for employees to enter time in and out in three separate fields.

    Is it possible to calculate time different from drop down columns in an input table?

    Just like this form https://www.jotform.com/form/210404303329442#preview ?

    Hope I have clarified.

    Thanks.

  • Richie JotForm Support
    Replied on February 11, 2021 at 3:20 AM

    Hi princess5510,

    I have moved your question to a new support ticket to assists you better.

    Kindly follow this link https://www.jotform.com/answers/2890771.