functions

  • Thread starter Thread starter Guest
  • Start date Start date
One way:

Assume # of cases in A1, # of workers in B1, # of hours in C1, then:

D1: =(B1*C1)/A1
 
OK,

A1: 4
B1: 10:25
C1: 5122
D1: =(B1*C1)/A1

formatted as time, D1 returns 00:00:29 man-hours per case.

If you want to work in decimals rather than times, multiply B1 by 24 to
get 10.4166667 hours. Then D1 (formatted as general, or some other
Number format) returns 0.00813484 man-hours per case.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

functions to use 2
sum hours and minutes with Excel 2000 9
Timecard functions and formulas 1
Question About Importing Columns From A Datasheet to A Worksheet 4
salary defined by slab table 5
Formatting question with Round 3
Sum the values of cells based on fontcolor 1
Conditional formatting 2

Back
Top