Forum Discussion
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 ...
Mariusz thank you, appreciate it
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
Community Champion
Community ChampionHi Anonymous
You can try to add two columns like below.
Acceptance =
IF(
NOT ISBLANK( 'Table'[ACCEPTANCE_DATETIME] ),
VAR _hrs = HOUR( 'Table'[ACCEPTANCE_DATETIME] - 'Table'[JOB_BOOKING_DATETIME] )
RETURN
SWITCH(
TRUE(),
_hrs >= 0 && _hrs <= 2, "0-2hrs",
_hrs >= 3 && _hrs <= 4, "3-4hrs",
_hrs >= 5 && _hrs <= 12, "5-12hrs",
_hrs >= 13 && _hrs <= 24, "13-24hrs",
">24hrs"
)
)
Attempted =
IF(
NOT ISBLANK( 'Table'[ATTEMPTED_ACCEPTANCE_DATETIME] ),
VAR _hrs = HOUR( 'Table'[ATTEMPTED_ACCEPTANCE_DATETIME] - 'Table'[JOB_BOOKING_DATETIME] )
RETURN
SWITCH(
TRUE(),
_hrs >= 0 && _hrs <= 2, "0-2hrs",
_hrs >= 3 && _hrs <= 4, "3-4hrs",
_hrs >= 5 && _hrs <= 12, "5-12hrs",
_hrs >= 13 && _hrs <= 24, "13-24hrs",
">24hrs"
)
)
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
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?