Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 05 Sep 2015 14:44:50 +0200Time calculation - which formula is needed?https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/ I sum up times and the sum goes beyond 24h and need to multiply the hours with an hourly rate to create an invoice.
- Until 23:59 I can use the formula `=(HOUR(G15)+MINUTE(G15)/60)*320` to linearize the time
- Beyond 23:59 the used formula reduces the time value by 24h. This is the correct functionality of the HOUR(cell) function.
I searched Help and Help Wiki but it seems that I overlooked the solution.
I appreciate any help which lets me to linearize hours and minutes beyond 23:59. Sat, 05 Sep 2015 08:18:31 +0200https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/Answer by karolus for <p>I sum up times and the sum goes beyond 24h and need to multiply the hours with an hourly rate to create an invoice.</p>
<ul>
<li>Until 23:59 I can use the formula <code>=(HOUR(G15)+MINUTE(G15)/60)*320</code> to linearize the time </li>
<li>Beyond 23:59 the used formula reduces the time value by 24h. This is the correct functionality of the HOUR(cell) function.</li>
</ul>
<p>I searched Help and Help Wiki but it seems that I overlooked the solution. </p>
<p>I appreciate any help which lets me to linearize hours and minutes beyond 23:59. </p>
https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/?answer=57280#post-id-57280Hallo
Internally Date/Time-Values are stored in **units of Day**
for transfer into **units of hours** you need to multiply by 24
=G15*24 * hourly_rate
simply does the jobSat, 05 Sep 2015 10:22:01 +0200https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/?answer=57280#post-id-57280Comment by ROSt52 for <p>Hallo <br/>
Internally Date/Time-Values are stored in <strong>units of Day</strong> <br/>
for transfer into <strong>units of hours</strong> you need to multiply by 24 </p>
<pre><code>=G15*24 * hourly_rate
</code></pre>
<p>simply does the job</p>
https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/?comment=57292#post-id-57292Thanks for the hint.
In Japanese I now need to say "hazukashii"... meaning I feel ashamed because I did not come up with the idea myself.
Hopefully it helps some other guys.Sat, 05 Sep 2015 14:44:50 +0200https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/?comment=57292#post-id-57292Answer by gDatKatz for <p>I sum up times and the sum goes beyond 24h and need to multiply the hours with an hourly rate to create an invoice.</p>
<ul>
<li>Until 23:59 I can use the formula <code>=(HOUR(G15)+MINUTE(G15)/60)*320</code> to linearize the time </li>
<li>Beyond 23:59 the used formula reduces the time value by 24h. This is the correct functionality of the HOUR(cell) function.</li>
</ul>
<p>I searched Help and Help Wiki but it seems that I overlooked the solution. </p>
<p>I appreciate any help which lets me to linearize hours and minutes beyond 23:59. </p>
https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/?answer=57283#post-id-57283You also may have to use separate formula for each side of the Day,
and add them together, (day1)+(day2),
to display your total time,
then multiply by your rate for funds.
simple for auditors and bosses to see.Sat, 05 Sep 2015 11:56:36 +0200https://ask.libreoffice.org/en/question/57277/time-calculation-which-formula-is-needed/?answer=57283#post-id-57283