Trick 009 Calculate the total working time of the device with power query

     Determine the number of hours worked by team members or the working time of equipment in the workshop. Determining the total number of hours worked can help you ensure they are paid the right amount or we can alternate operate machines

    There are many methods you can use to track and calculate hours worked.

    In this article, I will show you how to calculate total working hours in excel using power query.

    This is an example of calculating the total working time of the machines in the factory.

Link to download excel file.