I am trying to total Normal Pay but the formula does not Multiply Regular Hours by Normal Rate hence I get an
R6.33 sum instead of
I would appreciate assistance with a formula to calculate Currency/Price from Duration or Time.
Also how to auto sum other cells? example - this formula
=SUM(H2:H*1.5)to be applied every time a new input is made on the column?