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
  • 162,382
baffled
  • 41

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
  • 162,382