Forum Discussion

Keston's avatar
Keston
Frequent Visitor
1 year ago

Working Hours Between two date/time fields

Hello,   Seeking the assistance of the forum, I have two date/time fields in the following format and the following script to calculate the working hours between 8 - 1700 excluding weekend. The scr...
lbendlin's avatar
lbendlin
Super User
1 year ago

You could use ABS() to always get a positive duration.

Keston's avatar
Keston
Frequent Visitor
1 year ago

Ok noted, just to be clear, I should replace CALENDAR() with ABS()?

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    var workingdays = FILTER(CALENDAR(MIN([Created],[Assigned]),MAX([Created],[Assigned])),WEEKDAY([Date],2)<6)