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

Question

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 almost perfect, but what I need is to tell it that - IF the formula all the way up to here: IF({Monday Start} = BLANK(), 0,DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes'))/60equals less than 5, then don't add the last step of subtracting the 0.5.  Is this possible?

Sho · Accepted Answer

Oh, I still hadn't answered your previous question.

How about a formula like this?

IF(
  AND({Monday Start},{Monday End}),
  IF(
    DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes')/60 >= 5,
    DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes')/60 - 0.5,
    DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes')/60
  ),
  0
)

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

Oh, I still hadn't answered your previous question.

How about a formula like this?

IF(
  AND({Monday Start},{Monday End}),
  IF(
    DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes')/60 >= 5,
    DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes')/60 - 0.5,
    DATETIME_DIFF({Monday End}, {Monday Start}, 'minutes')/60
  ),
  0
)

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

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded