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 have a huge data containing time in the following format


There are 50,000 records that need to be added up all these time.

Is there a quick macro for Open Office Calc or suggest some easy way to do it?

I have tried in the following ways without success:

  1. Copied all the data and pasted in the Calc
  2. After pasting the time, time automatically gets changed according to the Calc standard format.
  3. I cannot add up to the sum
share|improve this question

migrated from May 27 '11 at 20:53

This question came from our site for professional and enthusiast programmers.

In the paste step you should see a Text Import dialog box. In the Separated by section, check the Other box, then put a colon : in the text entry field to the right, then click OK. This will import your data in two columns of numbers. Presumably these are hours and minutes or minutes and seconds.

Generate a third column that is the sum of the first column and the second column divided by 60, that is =C1+C2/60. The new column is hours or minutes and you can sum that column to get the total hours or minutes. I'm guessing that is what you want. If not, please clarify your time format and what you are trying to get out of the sum.

share|improve this answer

You must log in to answer this question.