Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 28 Sep 2018 23:43:11 +0200Calculation Helphttps://ask.libreoffice.org/en/question/164979/calculation-help/ I made a spreadsheet telling me that I worked for 4:00 if I clocked in at 12:00 PM and clocked out at 4:00 PM. My hourly rate is $11.25. 4:00 formatted into a number gives me 0.17 and therefore if I do a $11.25*4:00 I get a $1.88 when in fact I made $45.00. Is there a way to multiply hourly rate by hours worked without changing the time or currency formatted cells?Thu, 06 Sep 2018 21:23:51 +0200https://ask.libreoffice.org/en/question/164979/calculation-help/Comment by ve3oat for <p>I made a spreadsheet telling me that I worked for 4:00 if I clocked in at 12:00 PM and clocked out at 4:00 PM. My hourly rate is $11.25. 4:00 formatted into a number gives me 0.17 and therefore if I do a $11.25*4:00 I get a $1.88 when in fact I made $45.00. Is there a way to multiply hourly rate by hours worked without changing the time or currency formatted cells?</p>
https://ask.libreoffice.org/en/question/164979/calculation-help/?comment=164981#post-id-164981The 0.17 seems to be the fraction of a day that you worked (4/24 = 0.166667). So just multiply the 0.17 by 24 then by your hourly rate (0.1666 * 24 * 11.25). The displayed value of 0.17 is rounded off and I expect that when you use the value in the cell you will find it actually has more digits of accuracy than what is displayed.Thu, 06 Sep 2018 21:57:07 +0200https://ask.libreoffice.org/en/question/164979/calculation-help/?comment=164981#post-id-164981Comment by chippedcracker for <p>I made a spreadsheet telling me that I worked for 4:00 if I clocked in at 12:00 PM and clocked out at 4:00 PM. My hourly rate is $11.25. 4:00 formatted into a number gives me 0.17 and therefore if I do a $11.25*4:00 I get a $1.88 when in fact I made $45.00. Is there a way to multiply hourly rate by hours worked without changing the time or currency formatted cells?</p>
https://ask.libreoffice.org/en/question/164979/calculation-help/?comment=164983#post-id-164983Thank you.Thu, 06 Sep 2018 22:47:16 +0200https://ask.libreoffice.org/en/question/164979/calculation-help/?comment=164983#post-id-164983Comment by ve3oat for <p>I made a spreadsheet telling me that I worked for 4:00 if I clocked in at 12:00 PM and clocked out at 4:00 PM. My hourly rate is $11.25. 4:00 formatted into a number gives me 0.17 and therefore if I do a $11.25*4:00 I get a $1.88 when in fact I made $45.00. Is there a way to multiply hourly rate by hours worked without changing the time or currency formatted cells?</p>
https://ask.libreoffice.org/en/question/164979/calculation-help/?comment=164995#post-id-164995Using time as a number for calculation can be complicated. I highly recommend reading all the documentation on time formats and time as a number, and then experiment to see what actually happens. It might slow you down at first but will pay off in the end by giving you increased confidence in the accuracy of your results.Fri, 07 Sep 2018 03:59:59 +0200https://ask.libreoffice.org/en/question/164979/calculation-help/?comment=164995#post-id-164995Answer by Schiavinatto for <p>I made a spreadsheet telling me that I worked for 4:00 if I clocked in at 12:00 PM and clocked out at 4:00 PM. My hourly rate is $11.25. 4:00 formatted into a number gives me 0.17 and therefore if I do a $11.25*4:00 I get a $1.88 when in fact I made $45.00. Is there a way to multiply hourly rate by hours worked without changing the time or currency formatted cells?</p>
https://ask.libreoffice.org/en/question/164979/calculation-help/?answer=167015#post-id-167015Multiplying Time per Currency made directly does not work.
The correct way to make the hour value become a pure number, is done by multiplying this value by 24. Then the multiplication looks like this: ValueTime x 24 x ValueMode.
https://wiki.documentfoundation.org/images/9/91/HoraxMoeda.odsFri, 28 Sep 2018 23:43:11 +0200https://ask.libreoffice.org/en/question/164979/calculation-help/?answer=167015#post-id-167015