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 https://github.com/jbotes/powerbiTuto... Other Links List Generate https://learn.microsoft.com/en-us/pow... sharp duration https://learn.microsoft.com/en-us/pow... table from list https://learn.microsoft.com/en-us/pow... splitter split by nothing https://learn.microsoft.com/en-us/pow... value types https://learn.microsoft.com/en-us/pow... sharp time https://learn.microsoft.com/en-us/pow...