[fr-users] Calc - total of hours

Dear all

I wish you an Happy New Year 2014 !

On Calc, i'm not able to calculate a total of hours.
If column A is in format "hours:mn", i couldn't  have a total valid.
For example :
in A1 : "50:00:00" give 2 hours 30 mn !
in A2: "50:00:00" give 2 hours 30 mn!

In A3, total of A2+A3 give "5:00:00" !

I will have :
in A1 :50h00 
In A2:50h00
Total in A3 : 100h00

But i can't have this total.

Have anyone the solution ?

Thanks in advance for your help

Herve49



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-total-of-hours-tp4090785.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Envoyez un mail à users+unsubscribe@fr.libreoffice.org pour savoir comment vous désinscrire
Les archives de la liste sont disponibles à http://listarchives.libreoffice.org/fr/users/
Tous les messages envoyés sur cette liste seront archivés publiquement et ne pourront pas être 
supprimés