Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Time Intervals

Hi,   I've got a few DateTime columns: Job Booking datetime Attempted Acceptance datetime Acceptance datetime For the time differences between them e.g. time between Job Booking to Attempted ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Mariusz thank you, appreciate it

  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

    If (WEEKDAY(Date, 2) = 6 || WEEKDAY(Date,2) = 7, “”,The formula applied above)

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel 

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

 

 

Sorry, yes I've adjusted my post.

 

 

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz thank you, appreciate it

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Mariusz how do I exclude weekends (Sat & Sun) from this function? 

    i.e. if Job_Booking_DateTime is on Sat or Sun, then exclude from calculation

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi Anonymous ,

      If (WEEKDAY(Date, 2) = 6 || WEEKDAY(Date,2) = 7, “”,The formula applied above)

      If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
      Nathaniel 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thank you Nathaniel_C , just wasn't sure where to wrap that formula in the current function. Thanks for clarifying, appreciate it.