Originally Posted by faerk

Help please - I am a novice when it comes to spreadsheet-functions!
In a spreadsheet I try to add hours exceeding 24 hrs. What I need is the
formula to put in the resulting cell, in order to get the result in hours and
minutes (not in hundreds) Ex:
05:10
01:50
06:30
10:20
09:00
00:00
Formula here?

"=SUM(A1:A6)*24" is giving me 20:00, using "user-defined tt:mm."

Using "Digits", the result gives 32,83" -

where the result was supposed to be 32:50 hours and minutes."

Best regards,
Faerk (frm. Denmark)