1

I am trying to create a Timesheet using Google Sheet but this formula =IF((F8>8),(F8-8),"0") returns zero even on cells with Total Hours greater than 8

enter image description here

I have set both Formats to Duration

0

1 Answer 1

0

=ARRAYFORMULA(IF(LEN(F2:F), IF(TIMEVALUE(F2:F)>0.3333333333, 
 TEXT(F2:F-0.3333333333, "hh:mm:ss"), 0), ))

0

10
  • F formatted as Time and G formatted as Automatic or Time
    – user0
    Apr 4, 2019 at 9:46
  • 1
    Thank you so much, I appreciate your assistance!! Apr 4, 2019 at 15:05
  • I am trying to create a Regular Hours Worked column were data will be taken from Hours Worked. I opted to modify this formula =ARRAYFORMULA(IF(LEN(F2:F), IF(TIMEVALUE(F2:F)>0.3333333333, TEXT(0.3333333333, "hh:mm:ss"),F2:F), )) But I get this result if hours are less than 8 or 0.3333333333. The formula workes for hours greater than 8 Apr 4, 2019 at 17:12
  • maybe like this: =ARRAYFORMULA(IF(LEN(F2:F), IF(TIMEVALUE(F2:F)>0.3333333333, TEXT(0.3333333333, "hh:mm:ss"),TEXT(F2:F,"hh:mm:ss")),))
    – user0
    Apr 4, 2019 at 19:45
  • 1
    Eish, it's amazing how a comma can give one nightmares. Thank you so much!! Apr 15, 2019 at 21:52

Your Answer

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

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