Jay108 - profile

Jay108 · Aug 24, 2023

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...

Jay108 · Aug 22, 2023

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')) ...

Jay108 · Aug 25, 2023

@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!

Jay108 · Aug 23, 2023

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...

Jay108 · Aug 22, 2023

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...

User Statistics

User Activity

How to modify only one specific part of the formula IF - example below

How to subtract a lunch break from daily hours

Re: How to modify only one specific part of the formula IF - example below

Re: How to subtract a lunch break from daily hours

Re: How to subtract a lunch break from daily hours