Forum Discussion
Working Hours between two datetimes M-F (Including Saturdays)
I'm trying to figure out to how to implement working hours from two different datetimes. M-F (8A-5P) SATURDAY (8A-4P) Must disregard Holidays I've tried using this method from Bill Szysz but I'...
rogerthat You could have a holidy table and in the __NetWorkDays VAR formula you could do an EXCEPT around the CALENDAR statement to exclude the holidays. Also, in that same statement you would want <7 instead of <6 in order to include Saturdays.
Greg_Deckler I'm not sure the calculation is correct for me
For example, for
| start | end | expected | result |
| 9/17/2021 19:58 | 9/17/2021 21:50 | 0 | 112 |