Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 17 May 2017 14:31:48 +0200Running total/cumulative sum of time?https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/Attached is an example document to help elucidate my question:
[C:\fakepath\Running total:cumulative sum of time example.ods](/upfiles/14950217499189278.ods)
In this document I want to use a formula to make a running total of the time logged. However, I don't want to convert the hours into minutes; I would like the figures to remain HH/MM/SS.
Obviously when the minutes reach 60, they should be converted into an hour, then reset, and when the seconds reach 60, they should be converted into a minute, then reset.
I would prefer that this could be done with the hours, minutes and seconds divided into 3 cells as shown, but if not possible, then placing all within the same cell would be acceptable.
How can I achieve this?
Cheers.
**-EDIT-** I have received an answer from **JohnSUN** that works.
I am leaving this thread open a little longer for the purpose of further discussion, but I am satisfied with this solution.
Will also take a look at some of the other answers when I get more time, thanks to all who have contributed.
***Here is the updated document, with the problem solved using JohnSUN's directions***:
[C:\fakepath\Running total; cumulative sum of time example UPDATED W: JOHNSUN'S ANSWER.ods](/upfiles/14950216461515751.ods)Sat, 13 May 2017 18:08:12 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/Answer by JohnSUN for <p>Attached is an example document to help elucidate my question:</p>
<p><a href="/upfiles/14950217499189278.ods">C:\fakepath\Running total:cumulative sum of time example.ods</a></p>
<p>In this document I want to use a formula to make a running total of the time logged. However, I don't want to convert the hours into minutes; I would like the figures to remain HH/MM/SS.</p>
<p>Obviously when the minutes reach 60, they should be converted into an hour, then reset, and when the seconds reach 60, they should be converted into a minute, then reset.</p>
<p>I would prefer that this could be done with the hours, minutes and seconds divided into 3 cells as shown, but if not possible, then placing all within the same cell would be acceptable.</p>
<p>How can I achieve this?</p>
<p>Cheers.</p>
<p><strong>-EDIT-</strong> I have received an answer from <strong>JohnSUN</strong> that works.
I am leaving this thread open a little longer for the purpose of further discussion, but I am satisfied with this solution.
Will also take a look at some of the other answers when I get more time, thanks to all who have contributed.</p>
<p><strong><em>Here is the updated document, with the problem solved using JohnSUN's directions</em></strong>:</p>
<p><a href="/upfiles/14950216461515751.ods">C:\fakepath\Running total; cumulative sum of time example UPDATED W: JOHNSUN'S ANSWER.ods</a></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?answer=95123#post-id-95123You can use a simple formula for converting the hours-minutes-seconds into one value and format this value as desired
![Calculate total time](/upfiles/14947746167194101.png)
Sun, 14 May 2017 17:11:00 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?answer=95123#post-id-95123Comment by appreciatethehelp for <p>You can use a simple formula for converting the hours-minutes-seconds into one value and format this value as desired</p>
<p><img alt="Calculate total time" src="/upfiles/14947746167194101.png"></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95406#post-id-95406Whoops, I must've had my eye on the formula in E3, **of course** there's an opening parenthesis!
Sorry fellas.
Aaaand JohnSUN's answer worked perfectly. Have updated my question accordingly.
Just one more question for JohnSUN though, when you say "format this value as desired"- how exactly would I go about spreading the converted time in the "running total" column into 3 separate sections, similar to the "TIME (reading)" column?Wed, 17 May 2017 13:56:17 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95406#post-id-95406Comment by appreciatethehelp for <p>You can use a simple formula for converting the hours-minutes-seconds into one value and format this value as desired</p>
<p><img alt="Calculate total time" src="/upfiles/14947746167194101.png"></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95397#post-id-95397I formatted the "running total" F column cells using the time format shown in your answer.
I then tried using the formula you gave for cell D2: "=**A2+(B2+C2/60)/60)/24**", but in doing so was confronted with this message:
"LibreOffice Calc found an error in the formula entered.
Do you want to accept the correction proposed below?
**=A2+(B2+C2/60)/60/24**"
When "no" was selected, I got an "**Err:508**" message. When "yes" was selected, the result was **96:38:14**
*-continued below-*Wed, 17 May 2017 12:31:32 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95397#post-id-95397Comment by appreciatethehelp for <p>You can use a simple formula for converting the hours-minutes-seconds into one value and format this value as desired</p>
<p><img alt="Calculate total time" src="/upfiles/14947746167194101.png"></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95399#post-id-95399I am not sure why I got a different result to you. **So, instead of using a formula for cell D2, I tried typing the time in manually: 04:38:14**.
I then used the other formulas you gave for cells **D3** and **D4**, which worked perfectly.
You have solved my problem, thank you very, very much.
Will leave this thread open for further discussion regarding the discrepancy between my result in cell D2 and yours, however I am pretty satisfied with the outcome.Wed, 17 May 2017 13:10:29 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95399#post-id-95399Comment by Mike Kaganski for <p>You can use a simple formula for converting the hours-minutes-seconds into one value and format this value as desired</p>
<p><img alt="Calculate total time" src="/upfiles/14947746167194101.png"></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95401#post-id-95401Please check the @JohnSUN's answer closely: there is an opening parenthesis before A2 that you missed.Wed, 17 May 2017 13:29:30 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95401#post-id-95401Comment by JohnSUN for <p>You can use a simple formula for converting the hours-minutes-seconds into one value and format this value as desired</p>
<p><img alt="Calculate total time" src="/upfiles/14947746167194101.png"></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95403#post-id-95403I don't see in your variant of the formula the first opening bracket before A2: `=(A2+(B2+C2/60)/60)/24`Wed, 17 May 2017 13:30:20 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95403#post-id-95403Comment by JohnSUN for <p>You can use a simple formula for converting the hours-minutes-seconds into one value and format this value as desired</p>
<p><img alt="Calculate total time" src="/upfiles/14947746167194101.png"></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95407#post-id-95407You can use functions `=MINUTE(D2)` and `=SECOND(D2)` for additional columns. With the amount of hours the formula is a little more complicated `=INT(D2)*24+HOUR(D2)` (or just format cells in column D with code `[HH]`)Wed, 17 May 2017 14:31:48 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95407#post-id-95407Answer by Mike Kaganski for <p>Attached is an example document to help elucidate my question:</p>
<p><a href="/upfiles/14950217499189278.ods">C:\fakepath\Running total:cumulative sum of time example.ods</a></p>
<p>In this document I want to use a formula to make a running total of the time logged. However, I don't want to convert the hours into minutes; I would like the figures to remain HH/MM/SS.</p>
<p>Obviously when the minutes reach 60, they should be converted into an hour, then reset, and when the seconds reach 60, they should be converted into a minute, then reset.</p>
<p>I would prefer that this could be done with the hours, minutes and seconds divided into 3 cells as shown, but if not possible, then placing all within the same cell would be acceptable.</p>
<p>How can I achieve this?</p>
<p>Cheers.</p>
<p><strong>-EDIT-</strong> I have received an answer from <strong>JohnSUN</strong> that works.
I am leaving this thread open a little longer for the purpose of further discussion, but I am satisfied with this solution.
Will also take a look at some of the other answers when I get more time, thanks to all who have contributed.</p>
<p><strong><em>Here is the updated document, with the problem solved using JohnSUN's directions</em></strong>:</p>
<p><a href="/upfiles/14950216461515751.ods">C:\fakepath\Running total; cumulative sum of time example UPDATED W: JOHNSUN'S ANSWER.ods</a></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?answer=95079#post-id-95079This is not an answer; I use "answer" only to be able to attach a file (comment doesn't seem to give me this ability), and the file is just a demonstration of the most correct @Lupp's suggestion to use usual times.
[cumulative.ods](/upfiles/14947091036754892.ods)Sat, 13 May 2017 22:58:40 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?answer=95079#post-id-95079Comment by Lupp for <p>This is not an answer; I use "answer" only to be able to attach a file (comment doesn't seem to give me this ability), and the file is just a demonstration of the most correct <a href="/en/users/11185/lupp/">@Lupp</a>'s suggestion to use usual times.</p>
<p><a href="/upfiles/14947091036754892.ods">cumulative.ods</a></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95081#post-id-95081I did a bit of additional demo. It's concerning feasible solutions - and also stressing the risks.
I will now attach the demo to my answer by editing.Sat, 13 May 2017 23:39:43 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95081#post-id-95081Answer by Lupp for <p>Attached is an example document to help elucidate my question:</p>
<p><a href="/upfiles/14950217499189278.ods">C:\fakepath\Running total:cumulative sum of time example.ods</a></p>
<p>In this document I want to use a formula to make a running total of the time logged. However, I don't want to convert the hours into minutes; I would like the figures to remain HH/MM/SS.</p>
<p>Obviously when the minutes reach 60, they should be converted into an hour, then reset, and when the seconds reach 60, they should be converted into a minute, then reset.</p>
<p>I would prefer that this could be done with the hours, minutes and seconds divided into 3 cells as shown, but if not possible, then placing all within the same cell would be acceptable.</p>
<p>How can I achieve this?</p>
<p>Cheers.</p>
<p><strong>-EDIT-</strong> I have received an answer from <strong>JohnSUN</strong> that works.
I am leaving this thread open a little longer for the purpose of further discussion, but I am satisfied with this solution.
Will also take a look at some of the other answers when I get more time, thanks to all who have contributed.</p>
<p><strong><em>Here is the updated document, with the problem solved using JohnSUN's directions</em></strong>:</p>
<p><a href="/upfiles/14950216461515751.ods">C:\fakepath\Running total; cumulative sum of time example UPDATED W: JOHNSUN'S ANSWER.ods</a></p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?answer=95064#post-id-95064At first a question: For what reason are the durations logged in three parts (h, min, s) instead of one standard time value?
As long as you keep time values based on the default unit of 1 day (d) there is not the least problem to get your cumulative sum. You can simply add such values as you would add values of any other kind of quantity.
Ok. You have to enter durations as if they are TOD values.
Most users wouldn't care or not even regard the difference. In addition you may display the results in a format better appropriate for durations like done by the format code `H" h "MM" min "SS" s"`.
Actually calculating the 3-column-TimeValues cannot be done by a single "formula". You **either** need helper columns where the "logged" numbers are converted to default time values and then added. Based on these results you can convert back to seperate results in 3 columns using mathematical functions. Or you calculate the sums starting with the least significant part (s) and looking for the carry yourself. This cannot be done (imo) by the same formula in the three columns. as an example `=F1+C2+IF(CURRENT()>=60;-60;0)` in F2 (seconds) should do what you want. But as long as you do not dedicate a column to the carry, you need the rather complicated `=E1+B2+ROUNDUP((F1+C2-F2)/60)+IF(CURRENT()>=60;-60;0)` (or something similar) in E3. ...
**(Editing:)**
See also **[this](/upfiles/14947168034013914.ods)** demo. *(A fluke led me back, and I noticed that I had attached a bad version. The new one should do better.)*
Consider to regard the difference between "time" as TimeOfDay and "time" as duration (or as a scientific / technical kind of quantity). The difference is essential, though often ignored.
Science strongly prefers to express time values in **one single unit per application case**: Either only seconds (s) or only years in practise, rarely hours.
The mixed format used for TOD (and angles) goes back to an about 5000 years old tradition to [subdivide and to bunch by 60](https://en.wikipedia.org/wiki/Sexagesimal) which was abandoned for most applications also some millennia ago. Why? It's simply too unhandy as soon as you need real calculations.Sat, 13 May 2017 19:29:22 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?answer=95064#post-id-95064Comment by Mike Kaganski for <p>At first a question: For what reason are the durations logged in three parts (h, min, s) instead of one standard time value? <br>
As long as you keep time values based on the default unit of 1 day (d) there is not the least problem to get your cumulative sum. You can simply add such values as you would add values of any other kind of quantity. </p>
<p>Ok. You have to enter durations as if they are TOD values. <br>
Most users wouldn't care or not even regard the difference. In addition you may display the results in a format better appropriate for durations like done by the format code <code>H" h "MM" min "SS" s"</code>. </p>
<p>Actually calculating the 3-column-TimeValues cannot be done by a single "formula". You <strong>either</strong> need helper columns where the "logged" numbers are converted to default time values and then added. Based on these results you can convert back to seperate results in 3 columns using mathematical functions. Or you calculate the sums starting with the least significant part (s) and looking for the carry yourself. This cannot be done (imo) by the same formula in the three columns. as an example <code>=F1+C2+IF(CURRENT()>=60;-60;0)</code> in F2 (seconds) should do what you want. But as long as you do not dedicate a column to the carry, you need the rather complicated <code>=E1+B2+ROUNDUP((F1+C2-F2)/60)+IF(CURRENT()>=60;-60;0)</code> (or something similar) in E3. ... </p>
<p><strong>(Editing:)</strong> <br>
See also <strong><a href="/upfiles/14947168034013914.ods">this</a></strong> demo. <em>(A fluke led me back, and I noticed that I had attached a bad version. The new one should do better.)</em> <br>
Consider to regard the difference between "time" as TimeOfDay and "time" as duration (or as a scientific / technical kind of quantity). The difference is essential, though often ignored. <br>
Science strongly prefers to express time values in <strong>one single unit per application case</strong>: Either only seconds (s) or only years in practise, rarely hours. </p>
<p>The mixed format used for TOD (and angles) goes back to an about 5000 years old tradition to <a href="https://en.wikipedia.org/wiki/Sexagesimal">subdivide and to bunch by 60</a> which was abandoned for most applications also some millennia ago. Why? It's simply too unhandy as soon as you need real calculations.</p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95093#post-id-95093While I agree with usefulness of the single-unit approach, I wanted to mention that the different units aren't something abandoned in most applications, as well as something conceptually alien. First, the positional number representation itself is the sample of such concept (each digit place representing its own "unit" - in decimal, it's singles, tens, hundreds etc); second, there are a lot of places like heights (feet+inch) or weights (lb+oz) etc which are common now.Sun, 14 May 2017 08:10:36 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95093#post-id-95093Comment by Mike Kaganski for <p>At first a question: For what reason are the durations logged in three parts (h, min, s) instead of one standard time value? <br>
As long as you keep time values based on the default unit of 1 day (d) there is not the least problem to get your cumulative sum. You can simply add such values as you would add values of any other kind of quantity. </p>
<p>Ok. You have to enter durations as if they are TOD values. <br>
Most users wouldn't care or not even regard the difference. In addition you may display the results in a format better appropriate for durations like done by the format code <code>H" h "MM" min "SS" s"</code>. </p>
<p>Actually calculating the 3-column-TimeValues cannot be done by a single "formula". You <strong>either</strong> need helper columns where the "logged" numbers are converted to default time values and then added. Based on these results you can convert back to seperate results in 3 columns using mathematical functions. Or you calculate the sums starting with the least significant part (s) and looking for the carry yourself. This cannot be done (imo) by the same formula in the three columns. as an example <code>=F1+C2+IF(CURRENT()>=60;-60;0)</code> in F2 (seconds) should do what you want. But as long as you do not dedicate a column to the carry, you need the rather complicated <code>=E1+B2+ROUNDUP((F1+C2-F2)/60)+IF(CURRENT()>=60;-60;0)</code> (or something similar) in E3. ... </p>
<p><strong>(Editing:)</strong> <br>
See also <strong><a href="/upfiles/14947168034013914.ods">this</a></strong> demo. <em>(A fluke led me back, and I noticed that I had attached a bad version. The new one should do better.)</em> <br>
Consider to regard the difference between "time" as TimeOfDay and "time" as duration (or as a scientific / technical kind of quantity). The difference is essential, though often ignored. <br>
Science strongly prefers to express time values in <strong>one single unit per application case</strong>: Either only seconds (s) or only years in practise, rarely hours. </p>
<p>The mixed format used for TOD (and angles) goes back to an about 5000 years old tradition to <a href="https://en.wikipedia.org/wiki/Sexagesimal">subdivide and to bunch by 60</a> which was abandoned for most applications also some millennia ago. Why? It's simply too unhandy as soon as you need real calculations.</p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95095#post-id-95095Another (and much more important) thing to note is that the help in LO is created by volunteers, just as LO itself, and just like this ask's answers. So, each time you add an answer that you think worth of being reflected in help, and don't actually propose a patch to help, it's a sad thing happening.Sun, 14 May 2017 08:21:10 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95095#post-id-95095Comment by Lupp for <p>At first a question: For what reason are the durations logged in three parts (h, min, s) instead of one standard time value? <br>
As long as you keep time values based on the default unit of 1 day (d) there is not the least problem to get your cumulative sum. You can simply add such values as you would add values of any other kind of quantity. </p>
<p>Ok. You have to enter durations as if they are TOD values. <br>
Most users wouldn't care or not even regard the difference. In addition you may display the results in a format better appropriate for durations like done by the format code <code>H" h "MM" min "SS" s"</code>. </p>
<p>Actually calculating the 3-column-TimeValues cannot be done by a single "formula". You <strong>either</strong> need helper columns where the "logged" numbers are converted to default time values and then added. Based on these results you can convert back to seperate results in 3 columns using mathematical functions. Or you calculate the sums starting with the least significant part (s) and looking for the carry yourself. This cannot be done (imo) by the same formula in the three columns. as an example <code>=F1+C2+IF(CURRENT()>=60;-60;0)</code> in F2 (seconds) should do what you want. But as long as you do not dedicate a column to the carry, you need the rather complicated <code>=E1+B2+ROUNDUP((F1+C2-F2)/60)+IF(CURRENT()>=60;-60;0)</code> (or something similar) in E3. ... </p>
<p><strong>(Editing:)</strong> <br>
See also <strong><a href="/upfiles/14947168034013914.ods">this</a></strong> demo. <em>(A fluke led me back, and I noticed that I had attached a bad version. The new one should do better.)</em> <br>
Consider to regard the difference between "time" as TimeOfDay and "time" as duration (or as a scientific / technical kind of quantity). The difference is essential, though often ignored. <br>
Science strongly prefers to express time values in <strong>one single unit per application case</strong>: Either only seconds (s) or only years in practise, rarely hours. </p>
<p>The mixed format used for TOD (and angles) goes back to an about 5000 years old tradition to <a href="https://en.wikipedia.org/wiki/Sexagesimal">subdivide and to bunch by 60</a> which was abandoned for most applications also some millennia ago. Why? It's simply too unhandy as soon as you need real calculations.</p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95111#post-id-95111@Mike Kaganski: Being a developer you surely know that first of all functions need be clearly specified. The next step must be a correct implementation. With respect to the TIME function problems start here. The specification explicitly states in its last paragraph: *"Hours, minutes, and seconds may be any number (they shall not be limited to the ranges 0..24, 0..59, or 0..60 respectively).*
The implementation obviously ignores this. I wouldn't ennoble the bug anchoring it in the help.Sun, 14 May 2017 14:19:35 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95111#post-id-95111Comment by Lupp for <p>At first a question: For what reason are the durations logged in three parts (h, min, s) instead of one standard time value? <br>
As long as you keep time values based on the default unit of 1 day (d) there is not the least problem to get your cumulative sum. You can simply add such values as you would add values of any other kind of quantity. </p>
<p>Ok. You have to enter durations as if they are TOD values. <br>
Most users wouldn't care or not even regard the difference. In addition you may display the results in a format better appropriate for durations like done by the format code <code>H" h "MM" min "SS" s"</code>. </p>
<p>Actually calculating the 3-column-TimeValues cannot be done by a single "formula". You <strong>either</strong> need helper columns where the "logged" numbers are converted to default time values and then added. Based on these results you can convert back to seperate results in 3 columns using mathematical functions. Or you calculate the sums starting with the least significant part (s) and looking for the carry yourself. This cannot be done (imo) by the same formula in the three columns. as an example <code>=F1+C2+IF(CURRENT()>=60;-60;0)</code> in F2 (seconds) should do what you want. But as long as you do not dedicate a column to the carry, you need the rather complicated <code>=E1+B2+ROUNDUP((F1+C2-F2)/60)+IF(CURRENT()>=60;-60;0)</code> (or something similar) in E3. ... </p>
<p><strong>(Editing:)</strong> <br>
See also <strong><a href="/upfiles/14947168034013914.ods">this</a></strong> demo. <em>(A fluke led me back, and I noticed that I had attached a bad version. The new one should do better.)</em> <br>
Consider to regard the difference between "time" as TimeOfDay and "time" as duration (or as a scientific / technical kind of quantity). The difference is essential, though often ignored. <br>
Science strongly prefers to express time values in <strong>one single unit per application case</strong>: Either only seconds (s) or only years in practise, rarely hours. </p>
<p>The mixed format used for TOD (and angles) goes back to an about 5000 years old tradition to <a href="https://en.wikipedia.org/wiki/Sexagesimal">subdivide and to bunch by 60</a> which was abandoned for most applications also some millennia ago. Why? It's simply too unhandy as soon as you need real calculations.</p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95113#post-id-95113@Mike Kaganski (again): With respect to some statements of yours above, it might be preferable to have a private exchange. Since this site does not offer PM, I might (mis-?)use the mailing via the bugs site if you don't object. My true name is Wolfgang Jäger, and I am known by it to the https://bugs.documentfoundation.org/ .Sun, 14 May 2017 14:28:59 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95113#post-id-95113Comment by Mike Kaganski for <p>At first a question: For what reason are the durations logged in three parts (h, min, s) instead of one standard time value? <br>
As long as you keep time values based on the default unit of 1 day (d) there is not the least problem to get your cumulative sum. You can simply add such values as you would add values of any other kind of quantity. </p>
<p>Ok. You have to enter durations as if they are TOD values. <br>
Most users wouldn't care or not even regard the difference. In addition you may display the results in a format better appropriate for durations like done by the format code <code>H" h "MM" min "SS" s"</code>. </p>
<p>Actually calculating the 3-column-TimeValues cannot be done by a single "formula". You <strong>either</strong> need helper columns where the "logged" numbers are converted to default time values and then added. Based on these results you can convert back to seperate results in 3 columns using mathematical functions. Or you calculate the sums starting with the least significant part (s) and looking for the carry yourself. This cannot be done (imo) by the same formula in the three columns. as an example <code>=F1+C2+IF(CURRENT()>=60;-60;0)</code> in F2 (seconds) should do what you want. But as long as you do not dedicate a column to the carry, you need the rather complicated <code>=E1+B2+ROUNDUP((F1+C2-F2)/60)+IF(CURRENT()>=60;-60;0)</code> (or something similar) in E3. ... </p>
<p><strong>(Editing:)</strong> <br>
See also <strong><a href="/upfiles/14947168034013914.ods">this</a></strong> demo. <em>(A fluke led me back, and I noticed that I had attached a bad version. The new one should do better.)</em> <br>
Consider to regard the difference between "time" as TimeOfDay and "time" as duration (or as a scientific / technical kind of quantity). The difference is essential, though often ignored. <br>
Science strongly prefers to express time values in <strong>one single unit per application case</strong>: Either only seconds (s) or only years in practise, rarely hours. </p>
<p>The mixed format used for TOD (and angles) goes back to an about 5000 years old tradition to <a href="https://en.wikipedia.org/wiki/Sexagesimal">subdivide and to bunch by 60</a> which was abandoned for most applications also some millennia ago. Why? It's simply too unhandy as soon as you need real calculations.</p>
https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95117#post-id-95117@Lupp: my email is mikekaganski@hotmail.com; I'd like to discuss whatever you'd like to :)Sun, 14 May 2017 15:03:04 +0200https://ask.libreoffice.org/en/question/95056/running-totalcumulative-sum-of-time/?comment=95117#post-id-95117