1

https://docs.google.com/spreadsheets/d/13HdNN_qa9rhLFyMe0N9I9EusmBudi_dcdBkc6UeLHMM/edit#gid=878850570

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 at 23:55
  • Changed to Public – Sinethemba Gayiza Apr 15 at 23:58
  • how did you calculate 158.84? – user0 Apr 16 at 0:05
  • The 158.84 under Total Wages was calculated by an AppSheet App Formula and not Sheet Formula – Sinethemba Gayiza Apr 16 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 at 0:10
1

=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, ))

0


=ARRAYFORMULA(IF(LEN(A2:A), H2:H*1.5, ))

0


=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, ))

0


=ARRAYFORMULA(IF(LEN(A2:A), J2:J+K2:K, ))

0

  • 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 at 12:59
  • I am not familiar with Appsheet Timesheet App – user0 Apr 24 at 20:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.