Hi,
I’d like the Working Days column to give me the Time x Count value as business days (8 hour day) and not as 24 hours days. Any ideas on how I could do that ? This has baffled me for years…
Convert the “Time x Count” value first to hours then divide by 8 and you will get the number of 8h working days.
thisRow.[Time x count].ToHours() / 8
1 Like
I now see that hours are still not calculated correctly in the first example as the duration column still assumes the half day is 12 instead of 4 hours. To fix that we use a different formula:
Duration(Floor(thisRow.[Time x count].ToHours()/8), thisRow.[Time x count].ToHours() % 8)
2 Likes
Sorry @Nikola_Lajic , I hadn’t seen you answered by the time I got started with this.
My implementation is a bit more complex, but you can also consider start and end times and define different working hours per day 
Edit: I realize that this is not at all what @Lisa_Doucet was asking, but it was fun to build!
2 Likes
Thank you Nikola !! I never would have figured this out 
Thank you so much !
1 Like
Pablo thank you for taking the time as well