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.
Ok so here's the main formula I'm trying to use for my "Monday Pay Hours" fieldIF({Monday Start} = BLANK(), 0,DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes'))/60-0.5This gives me the exact hours worked, minus a half hour lunch break It's almos...
Hi all, I'm trying to create a formula to add on to a scheduling template I'm using. There is already a field for Monday hrs, Tuesday Hrs, etc. Formatted like this: IF({Monday Start} = BLANK(), 0,DATETIME_DIFF({Monday End}, {Monday Start}, 'hours')) ...
@Sho Thank you SO much!!! This worked like a charm! I don't entirely understand it, but it works!I've been tearing my hair out trying to solve this one for days. Nailed it!
Thanks so much @Sho Using the minutes / 60 worked great for getting the correct values. The above formula didn't work, but I just used this in the regular "Monday Hrs" field and it corrected the values: IF({Monday Start} = BLANK(), 0,DATETIME_DIFF({M...
And actually, upon more investigation, the above mentioned formula for the total daily hours is faulty - It can't divide into half hours; for some reason it defaults to round down to the closest hour, which is problematic. Surprising for a template t...
