Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 at 15:56

1 Answer 1

up vote 0 down vote accepted

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.