Forum Discussion

BoitumeloSegao1's avatar
BoitumeloSegao1
Qrew Member
3 years ago

Overtime formula


HI all please assist with the formula for the below. 



Duration - Formula Duration - Calculate duration between start and end time and subtract 1 hour if lunch is checked.

------------------------------
Boitumelo Segaole
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Try this

    [end time]-[start time]
    - IF([Lunch], Hours(1), Hours(0))

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------