Calculation error between number and hours

Greetings All.

I am trying to get hourly output rate from total output quantity divided by total hours worked but am getting error. Secondly unable to use the formula to convert but I could get the hourly output if the total hours entered manually.

Attached spreadsheet.

Example - Total Output is =SUM(C341,E341,G341,J341) = 21654. Total Hours is 15.45 (AA341) .

If using auto calculations - =SUM(C341,E341,G341,J341/(AA341) - The answer i get is = 24569 (The answer should be 1402)

Please guide where is the error. Thank you

=SUM(C341,E341,G341,J341)/AA341/24
15:45 is not 15,45 but 0,6562500 and nust be multiply with 24 then will be 15,75

=SUM(C341,E341,G341,J341/(AA341) is missing a bracket

=SUM(C341,E341,G341,J341)/(AA341) /24 gives 1375 which you have and is correct


The reason is 15:45 is 15hours and 45 minutes or decimal 15.75. it is not 15.45 which is what you are doing erroneously

Thank you BMV

Hi Davsth, Yes, I missed out the bracket and have amended as advised. The below formula works without creating a new total column.

=SUM(C341,E341,G341,J341)/(AA341) /24

Thank you.

Hi Kokosek,

The numbers C,E,G and J are the total production output for the day. My intention on the formula is get the hourly output without creating a new total column for C,E,G and J.

Wanted to avoid column AL, so that I could get the answer in column AK itself.

=SUM(C341,E341,G341,J341)/(AA341) /24

Thank you.