You work in a company that hire and pay workers on weekly basis. At the end of each week you have to provide the total number of hours those workers spent in order to pay them. You will be provided with one Excel file at the end of each week that contains two columns which you may use to extract the information needed.
You are asked to come up and use a formula that will calculate the total number of hours spent on each work order by calculating the difference between the actual start date column and actual end date column by a single click and drag.
Please note that work orders may not finish at the same day and AM and PM is another factor to pay attention to.