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 unable to put the Cut - Off timing for each working day.
2 Replies
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 dayFor 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
