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?

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

1 Answer 1

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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