Time calculation - basic time sheet calculation. Time card

  • Profile Image
    orisons.qa
    Asked on February 10, 2021 at 01: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

  • Profile Image
    Hiba 
    Answered on February 10, 2021 at 01:56 PM

    Facing same issue please help

  • Profile Image
    Alexander_G
    Answered on February 10, 2021 at 05: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

  • Profile Image
    Alexander_G
    Answered on February 10, 2021 at 06: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

  • Profile Image
    princess5510
    Answered on February 11, 2021 at 01: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.

  • Profile Image
    Richie_P
    Answered on February 11, 2021 at 03: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.