Power Query - Calculate Net Working Hours !!

[@subhrajyotisaha4u]

Friend - You are a rockstar. You have helped me in my work immensely with this video.

[@basensei8699]

now thats awesome!

[@jakubgrobelny4456]

Great, you helped me so much in my work!

[@basensei8699]

Glad to hear that!

[@rwna1996]

Exactly what I needed. Great stuff

[@roywilson9580]

Thanks for the interesting and useful video.

[@basensei8699]

a great pleasure!

[@guanhor1999]

This is great stuff, thx a lot 🙏

[@basensei8699]

glorious!

[@KeithHopewell]

Thanks for this tutorial really useful. However the calculation to remove Sat and Sunday does seem to be working? If I use start time as 8 and end time as 17 and run the report for a Friday at 15:00 and last date being Monday 10am I would expect a result of 4 working hours but I am getting a result of 13 suggesting its counting one of the weekend days. I have used 0 and 6 as per your no weekend calculation. Any Ideas?

[@JuanBatres-b3k]

Thank you Sensei! Pura vida!

[@pascalpauleau]

So great ! Thks for sharing. One complementary question : How do you exclude lunch breaks 12:00:01to 12:59:59 ?

[@kmposras]

Super useful TY

[@mnowako]

Marvelous! Thank you!

[@weyersjc]

Thank you Sensei!, Very useful.👊

[@anetterziebova8466]

Thank you for the video really great! One silly question though, how can I type in end time at 17.30 ?

[@basensei8699]

17.5 should do the trick

[@jbo1253]

@@basensei8699 i tried 17.5 for the business hours end but got the error: An error occurred in the ‘’ query. Expression.Error: The number is out of range of a 32 bit integer value.
Details:
17.5
Any ideas?

[@AnnaAngerer-l4d]

Hi! 😊I can't seem to find the advanced editor code for this video - could someone please help me out? Thank you 😊😊

[@basensei8699]

Anna did you get it sorted ? sorry only saw this now :(