Can i count "hours" in a row with SUM, but show Names/Characters in the cell?

53 Views Asked by At

I would like to let Google Sheets count "hours" in a row together, BUT we use "Characters" instead of Numbers when we update the Document.

Can we do a secondary Table and calculate everything together and then output the total number in the original table?

I've made a picture for a easier understanding:

https://i.imgur.com/IxXjIWL.png

1

There are 1 best solutions below

4
player0 On

try:

=ARRAYFORMULA(SUM(IFNA(HLOOKUP(A1:Q1; 
 {{"F" ; 8,5 }\ 
  {"U" ; 7,7 }\ 
  {"D" ; 2   }\ 
  {"N1"; 11,3}}; 2; 0))))

enter image description here


for multiple rows use:

=ARRAYFORMULA(MMULT(IFNA(HLOOKUP(A1:Q3; 
 {{"F" ; 8,5 }\ 
  {"U" ; 7,7 }\ 
  {"D" ; 2   }\ 
  {"N1"; 11,3}}; 2; 0))*1; ROW(INDIRECT("A1:A"&COLUMNS(A1:Q)))^0))

enter image description here