Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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 R152.00
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?
=ARRAYFORMULA(IF(LEN(A2:A),
(REGEXEXTRACT(TO_TEXT(F2:F), "\d+")+
(REGEXEXTRACT(TO_TEXT(F2:F), ":(\d+)"))/60+IFERROR
(REGEXEXTRACT(TO_TEXT(F2:F), "\d+:\d+:(\d+)")/3600))*H2:H, ))
=ARRAYFORMULA(IF(LEN(A2:A), H2:H*1.5, ))
=ARRAYFORMULA(IF(LEN(A2:A),
(REGEXEXTRACT(TO_TEXT(G2:G), "\d+")+IFERROR(
(REGEXEXTRACT(TO_TEXT(G2:G), ":(\d+)"))/60)+IFERROR
(REGEXEXTRACT(TO_TEXT(G2:G), "\d+:\d+:(\d+)")/3600))*I2:I, ))
=ARRAYFORMULA(IF(LEN(A2:A), J2:J+K2:K, ))
