Solved: DATEDIFF result in fraction just for weekdays

Anonymous · ‎10-19-2021

Hi Guys,

I want to do a DATEDIFF calculation and get the result in fractions.

So I can take the answer in this formula.

But can we change this to get the result only for weekdays and the result in fractions.

Thank you.

Fowmy · ‎10-19-2021

@Anonymous

Can you try the following Calculated Column?

Result =  (DATEDIFF( [Date1] , [Date2] , HOUR) - COUNTROWS( FILTER( CALENDAR( [Date1] , [Date2] ) , WEEKDAY([Date],2) IN {6,7} ) ) * 24) / 24

Did I answer your question? Mark my post as a solution! and hit thumbs up

Anonymous · ‎10-20-2021

Thanks @Fowmy

Fowmy · ‎10-19-2021

@Anonymous

Can you try the following Calculated Column?

Result =  (DATEDIFF( [Date1] , [Date2] , HOUR) - COUNTROWS( FILTER( CALENDAR( [Date1] , [Date2] ) , WEEKDAY([Date],2) IN {6,7} ) ) * 24) / 24

Did I answer your question? Mark my post as a solution! and hit thumbs up

DATEDIFF result in fraction just for weekdays