4

Libre Office Version: 5.2.5.1

Adding a column of hours:minutes (example: 5:30 + 3:00 + 12:30) that totals more than 23:59 gives 00:00.

Apparently hours over 24 = 1 day, so the clock starts over, but I don't see how to add a column that might have more (40?) hours in it. Other time formats do not seem to help, except I did get a correct answer breifly with one of the HH:MM:SS formats. However, it reverted to 00:00:0 after a few runs.

What to do?

Sample data:

enter image description here

Formula:

=((ENTRY.F7<ENTRY.G7)+ENTRY.G7-ENTRY.F7)+ENTRY.E7+ENTRY.H7
DavidPostill
  • 153,128
  • 77
  • 353
  • 394
baffled
  • 41
  • 1
  • 2
  • In excel, so I do not know if it works for LibreOffice, on would use the format: `[HH]:MM:SS` with the `HH` in `[]`. Not sure if that works in LibreOffice hence the comment and not an answer. – Scott Craner Feb 07 '17 at 15:07
  • Thanks, tried 24:30, discovered that the original colum, which is filled with data from another page, does NOT give the correct time total, but a test colume with the same numbers, typed into the cells, is correct, including product > 24 hrs - bafflled – baffled Feb 07 '17 at 15:20
  • Some diagrams or screen shots of your data would help us understand your question. Please [edit] your question to include some example (mock) data (before and after). See [Format Text as a Table](http://www.sensefulsolutions.com/2010/10/format-text-as-table.html) for a web utility that will help you to create a nice data table you can paste into your question. Upload any image(s) to [Imgur](http://www.imgur.com) and you will get link(s) you can share. [Edit] your question to include the link(s) and someone with sufficient reputation will inline the image(s) for you. – DavidPostill Feb 07 '17 at 15:40
  • Please [edit] the question **not** my answer. Your formula does not match your sample data image. That makes it useless - I am trying to reproduce your problem. If you can't [edit] the question and provide suitable sample data I will give up. – DavidPostill Feb 07 '17 at 16:51
  • 2
    Possible duplicate of [LibreOffice Calc: How to get total for HH:MM:SS cells](http://superuser.com/questions/387106/libreoffice-calc-how-to-get-total-for-hhmmss-cells) – tohuwawohu Feb 07 '17 at 17:29
  • 1
    @tohuwawohu We already know the duplicate doesn't fix his problem. See the comments under my answer. – DavidPostill Feb 07 '17 at 18:08

1 Answers1

4

I don't see how to add a column that might have more (40?) hours in it

As pointed out in a comment by Scott Craner, format the total cell as [HH]:MM:SS:

enter image description here

Tested with LibreOffice Calc 5.2.4.2.

DavidPostill
  • 153,128
  • 77
  • 353
  • 394