F
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)
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)