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

Suppose I have a column which contains time-deltas in the form hh:mm:ss. Now I want to add those times using sumif and get the total time in the format hh:mm:ss, too. Is there a way to do this in libreoffice-calc?

share|improve this question
    
This should "just work". A time entry in a cell is stored as a fraction of 24 hours. So 12 hours (or 12pm) is stored as .5. Summing them should be fine, provided you keep below 24 hours total otherwise it will wrap. What is your sumif formula? – Paul Nov 1 '11 at 22:38
    
Ok great, add this as an answer and accept it to get it off the unanswered list. – Paul Nov 2 '11 at 22:13
    
how do I sum if the total is greater than 24h? – Erik Allik Nov 26 '14 at 15:56
up vote 0 down vote accepted

Just change the format of the output-cell to hh:mm:ss

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .