New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Working hours without Holidays, weekends and by country in Power Query

In today’s video we are going to write a function that calculates work hour (seconds) between two datetimes.
Working hour by location, holidays will also be included 🙂

Watch the tutorial:

Working hours without Holidays, weekends and by country in power query

Links to the mentioned resources

Link to Bills thread: https://social.technet.microsoft.com/…

Was this helpful?
Previous Convert UTC datetime to local time zones in Power Query
Next Round time to nearest 15 min with Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents