Formula for adding cells formatted differently

[rcdunn2003]

I'm not an advanced user by any stretch. I have a worksheet which I nee
to add hours and minutes together, but in the same formula I need t
divide and multiply general numbers with the times as well. I do no
have a clue how to structure this formula. Below is an example of wha
I need to do, and attached is the worksheet itself. Can anyone help m
along here? *** FYI, these are not times of day,.i.e. am/pm, bu
rather cumulative hours and minutes for a production report.***


1:02 3:42 2:51=455 (minutes) 25692 /
455 * 60 = xx

I need to construct a formula in one cell which will calculate tota
number of minutes from numerous cells, after which I need to take
general number, divide it by the total number of minutes and multipl
by another general number.

***The attached spreadsheet has numerous worksheets, all the sam
format. Look at the first grid when you open, and this is the formul
I need;

Output / ODT+MDT+Run Time (total minutes) * 60 = PP

 

[Richard O. Neville]

Try using the function "Sumproduct," which may shortcut what you are trying
to do, which I don't totally understand. This function allows you to sum the
calculations from multiple cells and its syntax is explained in the Function
menu.