Power Query - Calculate Net Working Hours !!

Calculating the net amount of hours between a start and end time is a common requirement but for some strange reason it isn't provided for in power query so in this video I show you how to create a networking hour function that you can reuse in your power query projects. You can also just copy the code from the file link below and apply it immediately.
#workinghours #data #dataanalytics #excel #powerquery #powerbi #powerbidesktop #accounting #excelformula #calculation
Link
File created for this video
github.com/jbo...
Other Links
List Generate
learn.microsof...
sharp duration
learn.microsof...
table from list
learn.microsof...
splitter split by nothing
learn.microsof...
value types
learn.microsof...
sharp time
learn.microsof...

[@rwna1996]

Exactly what I needed. Great stuff

[@JuanBatres-b3k]

Thank you Sensei! Pura vida!

[@mnowako]

Marvelous! Thank you!

[@subhrajyotisaha4u]

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

[@basensei8699]

now thats awesome!

[@roywilson9580]

Thanks for the interesting and useful video.

[@basensei8699]

a great pleasure!

[@weyersjc]

Thank you Sensei!, Very useful.👊

[@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

[@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