# Total Wages Calculations

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`

1. I would appreciate assistance with a formula to calculate Currency/Price from Duration or Time.

2. 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?

• sheet is private – user0 Apr 15 '19 at 23:55
• Changed to Public – Sinethemba Gayiza Apr 15 '19 at 23:58
• how did you calculate 158.84? – user0 Apr 16 '19 at 0:05
• The 158.84 under Total Wages was calculated by an AppSheet App Formula and not Sheet Formula – Sinethemba Gayiza Apr 16 '19 at 0:08
• yeah, but is 158.84=8:21h * 19? in that case it should be E2*H2 not F2*H2, right? – user0 Apr 16 '19 at 0:10

``````=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, ))`` • Hi, I am using the google sheet on an Appsheet Timesheet App. I am trying to avoid having formulars that are not aligned, can you please assist me with a formula that would give a Total Hours = 17:00:00 if employee clocked in at 12:55pm today and ended 6:12am following day? I currently given a -6 | discourse-cdn-sjc1.com/business5/uploads/appsheet/original/2X/c/… – Sinethemba Gayiza Apr 24 '19 at 12:59
• I am not familiar with Appsheet Timesheet App – user0 Apr 24 '19 at 20:00