Forum Discussion
Working Day with Cut-Off timing
Hi, I want to create the Working Days Date Table with Cut-Off timing i.e. 06:00PM EST after 06:00PM Est it should consider the next day I was successful creating the Working Date Table but unabl...
This may be achievable in Power Query editor, if you can provide small piece of data with few Dates and times , i will try to help!
I have a Date Table in which I have excluded the Non Working Days i.e. US Holidays and Weekends.
Now i want Each day Cut-Off time till 06:00 PM EST after 06:01 PM EST it should count the next working day
For E.g
Feb 16th at 05:30PM EST is Feb 16th
But
Feb 16th after 06:01 PM EST should be Feb 17th (Next business Day)
Hope my question is clear now