LibreOffice SUM time period in format HH:MM:SS

time sum libreoffice calc
Gianluca picture Gianluca · May 22, 2013 · Viewed 10k times · Source

I want to obtain the sum of several cells containing a period of time in the format HH:MM:SS. In LibreOffice Calc 4.0.3.3, I've copy-pasted the periods of time in the range G14:G21, and formatted the cells as Time HH:MM:SS. I formatted in the same way the cell G22, and inserted in it the following SUM function:

=SUM(G14:G21)

Instead of the expected result, the function returns me this solution 00:00:00. Could you explain me where am I wrong?

Answer

hansfbaier picture hansfbaier · Apr 5, 2014

You have the wrong format. HH wraps around every 24 hours. Try using [HH] instead of HH, then you get the total number of hours.

Related questions

add NSTimeInterval to NSDate in cocoa

I've got a NSDate that represents a specific time. The format of that date is hhmmss. I want to add an NSInterval value (specified in seconds) to that time value. Example: NSDate = 123000 NSTimeInterval = 3600 Added together = 133000 What is the best way …

Read More
How to get the current time in Python

What is the module/method used to get the current time?

Read More
Java string to date conversion

What is the best way to convert a String in the format 'January 2, 2010' to a Date in Java? Ultimately, I want to break out the month, the day, and the year as integers so that I can use Date …

Read More