Overtime formula

Question

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 · Answer

Try this[end time]-[start time] - IF([Lunch], Hours(1), Hours(0))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Overtime formula

1 Reply

Related Content

Overtime formula Calculation Question

QrewTip: Formula Logic Order

Code Page Formula Button

Formula to calculate hours

GetRecords Formula Help