How to calculate time in a shift and deduct break using calculation

  • Profile Image
    kirpalttc
    Asked on December 28, 2020 at 06:29 AM

    Hi,

    I'm trying to calculate time in a shift and then deduct .5 hours for break if the shift hours are over 5 hours.

    Calculation is the way to go as I put that in my form but now I need to do the deduction based on the answer.

    Please assist.

    Thanks


    Kirpal

  • Profile Image
    Sam_G
    Answered on December 28, 2020 at 06:48 AM

    Hi Kirpalttc,

    Thank you for contacting Support.

    Let me work on this and will get back to you with an update.


  • Profile Image
    Sam_G
    Answered on December 28, 2020 at 06:56 AM

    Hi Kirpalttc,

    You can use the time field for a time in, time out, and lunch. 

    You can use the time field for a time in, time out, and lunch. 

    1533340013The Easiest Online Form Builde

    In my sample screenshot, I've added Lunch Out and Lunch In and the total number of hours they took for lunch.

    I've also used the form calculation widget to calculate the total of time in and time out + lunch out and lunch in.

    Sample formula:

    1533340218total_hours.png

    1533340182lunch.png

    You can check my sample form here https://form.jotform.com/203622558063958. Feel free to clone it if you want https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL.

    Let us know if you have any questions or if you need further assistance.