Calculate work hours less break

  • Profile Image
    Asked on February 09, 2021 at 04:09 PM


    For some reason my calculations based on conditions are not working in the form.

    It is for calculating hours of work subtracting 1/2 hours break or not.

    I have noticed that when I enter time and then hit backspace it starts to work.

    At times it works randomly.

    Please assist.


  • Profile Image
    Answered on February 09, 2021 at 08:24 PM

    I have checked the form you linked and based on my understanding, you would like to get the total time range of a Time field in your form into another field but, 0.5 hours would need to be deducted on the total hours that are more than 5 hours.


    To do that, you have passed the value of the Time field range into a Form Calculation widget.


    And then, you have used the Form Calculation widget in your condition to get the total.


    Your calculation seems to be working, however, you would need to also toggle the AM/PM dropdown of the Time field.


    Please give it a try and let us know if you need any further assistance.