Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 06 May 2019 00:20:36 +0200How to Calculate for only the 6th Day?https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/Greetings,
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?
Thanks.Sun, 05 May 2019 20:29:31 +0200https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/Answer by Starkman for <p>Greetings,</p>
<p>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).</p>
<p>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?</p>
<p>Thanks.</p>
https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?answer=192785#post-id-192785Going 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.Mon, 06 May 2019 00:20:36 +0200https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?answer=192785#post-id-192785Answer by Schiavinatto for <p>Greetings,</p>
<p>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).</p>
<p>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?</p>
<p>Thanks.</p>
https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?answer=192771#post-id-192771=IF(COUNTA(A1:A6)=6;SUM(A1:A6)*1,5;SUM(A1:A6))
Format the cell:
![image description](/upfiles/15570885248610793.png)
**Do not use drag hours, it adds 1 more day per cell spent.**Sun, 05 May 2019 22:21:27 +0200https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?answer=192771#post-id-192771Comment by karolus for <p>=IF(COUNTA(A1:A6)=6;SUM(A1:A6)*1,5;SUM(A1:A6))</p>
<p>Format the cell:</p>
<p><img alt="image description" src="/upfiles/15570885248610793.png"></p>
<p><strong>Do not use drag hours, it adds 1 more day per cell spent.</strong></p>
https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192778#post-id-192778@Gilberto Schiavinatto: wrong Formula, `the 6th day` only should be multplied by 1.5Sun, 05 May 2019 23:23:07 +0200https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192778#post-id-192778Comment by Schiavinatto for <p>=IF(COUNTA(A1:A6)=6;SUM(A1:A6)*1,5;SUM(A1:A6))</p>
<p>Format the cell:</p>
<p><img alt="image description" src="/upfiles/15570885248610793.png"></p>
<p><strong>Do not use drag hours, it adds 1 more day per cell spent.</strong></p>
https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192779#post-id-192779**=IF(COUNTA(A1:A6)=6;SUM(A1:A5)+(A6*1,5);SUM(A1:A6))**Sun, 05 May 2019 23:28:27 +0200https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192779#post-id-192779Comment by karolus for <p>=IF(COUNTA(A1:A6)=6;SUM(A1:A6)*1,5;SUM(A1:A6))</p>
<p>Format the cell:</p>
<p><img alt="image description" src="/upfiles/15570885248610793.png"></p>
<p><strong>Do not use drag hours, it adds 1 more day per cell spent.</strong></p>
https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192781#post-id-192781looks better ;-)Sun, 05 May 2019 23:33:07 +0200https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192781#post-id-192781Comment by Starkman for <p>=IF(COUNTA(A1:A6)=6;SUM(A1:A6)*1,5;SUM(A1:A6))</p>
<p>Format the cell:</p>
<p><img alt="image description" src="/upfiles/15570885248610793.png"></p>
<p><strong>Do not use drag hours, it adds 1 more day per cell spent.</strong></p>
https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192784#post-id-192784Thanks 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.Mon, 06 May 2019 00:17:51 +0200https://ask.libreoffice.org/en/question/192765/how-to-calculate-for-only-the-6th-day/?comment=192784#post-id-192784