title: Sum hours and minutes in a column in Openoffice Calc 4.1.1
body: <p>This is quite a tricky question.</p>
  
  <p>I'm trying to sum the hours and minutes in a column.</p>
  
  <p>I need it to show either in the format <code>[HH]:MM</code> (hours:minutes) or <code>DD HH:MM</code> (days hours:minutes).</p>
  
  <p>I've tried the <code>=SUM()</code> function but it work well. It shows as <code>04:30</code>, instead of the real value.<br>
  I've also tried other tricks (like other formats) and even some custom functions.</p>
  
  <p>All the columns have the format <code>HH:MM</code>.</p>
  
  <p>Here is the structure of the table:</p>
  
  <p><img src="https://i.stack.imgur.com/mXZy3.png" alt="enter image description here"></p>
  
  <p>I'm sorry about my terrible Paint skills. The 'hidden' part is just text. All those columns are introduced manually.<br>
  Where you see <code>=SOMA(D7:D37)</code>, is where I want the time showing.<br>
  <code>=SOMA()</code> is the equivalent of <code>=SUM()</code> for English versions. I'm using the Portuguese version.</p>