Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to do something very simple in LibreOffice Calc:

I have a set of simple CSV files that contain lists of durations, formatted as HH:MM:SS.

I need to make a SUM of those lists.

With some research, I figured out that the thing to do is to change the formatting of the cells, as it is explained here: LibreOffice Calc: How to get total for HH:MM:SS cells

The problem is: LibreOffice doesn't really apply this formatting to my cells.

If I type manually a value inside such a formatted cell, an entry such as 00:01.58 is treated correctly as a "time" value, gets aligned right, and adds to the final SUM.

However, all the values already present in the CSV aren't converted. They remain aligned left, and are considered as dumb strings. They remain firmly aligned left, and add nothing to the final SUM.

If I place my cursor at the end of one of those cells, and hit the "enter" key, LibreOffice transforms it into a number and aligns it right, and adds the duration to the end SUM. But I don't want to do this manually for hundreds of cells...

This is driving me nuts. How can I convince LibreOffice that those fields have to be treated as numeric time values?

Using LibreOffice on OSX 10.9.1.

share|improve this question
Try the solution proposed here. I'm almost sure that LO handles the time values in a correct way after the search/replace described there. – tohuwawohu Feb 2 '14 at 9:13
Thanks @tohuwawohu for this helpful link, it was exactly that. Those solutions work indeed. – Manu Feb 2 '14 at 11:22

You must log in to answer this question.

Browse other questions tagged .