Ask Your Question

How to Calculate for only the 6th Day?

asked 2019-05-05 20:29:31 +0200

Starkman gravatar image

updated 2020-08-05 14:57:55 +0200

Alex Kemp gravatar image


If I work six days in a row (A1:A6) in any given week, I get 1.5 times my regular pay for that sixth day alone (again, it has to be six days in a row in each week to qualify for that extra pay).

How do I have Calc look to see if all six days have hours and then calculate the six day's hours at 1.5 it's normal rate of pay per hour?


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-05-06 00:20:36 +0200

Starkman gravatar image

Going with what I got here, I've come up with this, which worked: =IF(COUNTBLANK(F5:F10)>=1,0,(1.5*F10)).

Thanks much, all.

edit flag offensive delete link more

answered 2019-05-05 22:21:27 +0200

updated 2019-05-05 22:37:01 +0200


Format the cell:

image description

Do not use drag hours, it adds 1 more day per cell spent.

edit flag offensive delete link more


@Gilberto Schiavinatto: wrong Formula, the 6th day only should be multplied by 1.5

karolus gravatar imagekarolus ( 2019-05-05 23:23:07 +0200 )edit


Schiavinatto gravatar imageSchiavinatto ( 2019-05-05 23:28:27 +0200 )edit

looks better ;-)

karolus gravatar imagekarolus ( 2019-05-05 23:33:07 +0200 )edit

Thanks very much! With what I got here, I went with this, which worked: =IF(COUNTBLANK(F5:F10)>=1,0,(1.5*F10))

Thanks very much for the help.

Starkman gravatar imageStarkman ( 2019-05-06 00:17:51 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-05 20:29:31 +0200

Seen: 86 times

Last updated: May 06 '19