Calculate the total number of hours spent on each work order

Reference no: EM131018748

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.

Reference no: EM131018748

Questions Cloud

Prepare an appropriate journal entry for transaction : Prepare journal entries, if needed, to reflect the dividend declaration, the date of record, and the date of payment - How much was net income for 20X7 and 20X8?

Initial leadership perspective and describes : Compose an essay (minimum 500-600 words) that summarizes your initial leadership perspective and describes the changes to your initial perspective that occurred after completing the questionnaire, interviews, and research.

What is the new market demand equation for coffee mugs : You read in the Friday newspaper that consumers have a linear demand for coffee mugs, wanting 50 coffee mugs at a price of $5/mug and 70 mugs at a price of $3/mug. What is the new market demand equation for coffee mugs

Advantages and disadvantages of developing new sales : What are the advantages and disadvantages of developing a New sales organization for the Western Region that would organize according to these customer types:

Calculate the total number of hours spent on each work order : 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 ..

Prepare the aggregate plan and compute its total cost : Regular output rate for periods 1,2, and 3 are 300; 0 for period 4; and 450 for the last 2 periods. Note, though, that the forecast of 400 units in period 4 must be dealt with. Prepare the aggregate plan, and compute its total cost.

Combination of overtime and subcontracting : Suppose you can use a combination of overtime and subcontracting, but you cannot use subcontracting in more than two periods, there is 6 periods. Up to 50 units of subcontracting and either 0 and 40 units of overtime are allowed per period.

How is a credit contract set up : How is a credit contract set up? What are the requirements? What statutes affect the credit contract? How are the pros and cons of contractual obligations?

Legal argument with the customer : The customer is threatening to take action. You do not really want to be involved in a legal argument with the customer. How can this be solved.

User Account

All Pages