Averaging Question

[RLJ]

I have a spreadsheet that I am trying to get an average for for how long it takes to do somthing. The spreadsheet has the start time, stop time and a total number for how many units were completed during the time period.

I have in cell G4 the total hours worked from subtracting E4-C4. In Cell H4 I have the total number of units completed.

Now what I need is to have the average amount of time it took to complete each unit.

So if my total time worked was 3hrs (180 minutes) and the total Number of units completed is 150, I need to see the average of 0.8 units per minute.

My problem is I can't simply divide the cells, because it comes up with an erroneous value since the Total Hours is in a time format and the total number of units is in a number format.

What can I do to accomplish this? It seems like I need to have an intermediate cell that converts the 3 hours to 180 minutes as a number to divide by.

Thanks for your help.

 

[doofusboy]

=(G4*60)/H4 should give you avg unit/minute

 

[T. Valko]

I have a spreadsheet that I am trying to get an average for for how long it takes to do somthing. The spreadsheet has the start time, stop time and a total number for how many units were completed during the time period.

I have in cell G4 the total hours worked from subtracting E4-C4. In Cell H4 I have the total number of units completed.

Now what I need is to have the average amount of time it took to complete each unit.

So if my total time worked was 3hrs (180 minutes) and the total Number of units completed is 150, I need to see the average of 0.8 units per minute.

My problem is I can't simply divide the cells, because it comes up with an erroneous value since the Total Hours is in a time format and the total number of units is in a number format.

What can I do to accomplish this? It seems like I need to have an intermediate cell that converts the 3 hours to 180 minutes as a number to divide by.

Thanks for your help.

Try this...

To convert the total time to minutes:

=(end_time-start_time)*1440

 

[RLJ]

Thanks

 

[T. Valko]

Thanks

You're welcome!