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 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz thank you for quick response. I notice the two column functions are exactly the same or am I missing something?

 

Or did you mean one column for Acceptance datetime and the other for Attempted Acceptance datetime?

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