This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Is there a way to use the datetime_diff formula (or maybe something else) to calculate how much time an employee missed by coming late, leaving early, or not coming in at all?
Thanks!
Kamille_Parks:
IF(AND({Start Date}, {End Date}), MAX(DATETIME_DIFF({End Date}, {Start Date}, ‘seconds’), 0), 0) - {Scheduled Shift Length}
Thank you for all your help.
The formulas are working but not giving me the right calculation. What am ...