Are you setting up Monday templates with formulas for your team? Add this formula in one of our expert-created Monday templates.
Are you setting up Monday templates with formulas for your team? Add this formula in one of our expert-created Monday templates.
Contents
The formula is:
IF(HOURS_DIFF({Break End}, {Break Start}) > "0", HOURS_DIFF(HOURS_DIFF({End Time}, {Start Time}), HOURS_DIFF({Break End}, {Break Start})), HOURS_DIFF({End Time}, {Start Time}))
↑ Copy and paste into Monday then switch out the bold property name/s in the formula to match the name of the property name/s you’re using.
The steps to creating a date formula in Monday are:
The steps to editing a date formula in Monday are: