Need help adding hours exceeding 24 hours

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

gearcutter

faerk;710496 said:
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 i
the
formula to put in the resulting cell, in order to get the result i
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)

Hi Faerk
assuming your formula =Sum(A1:A6) is in cell A7 format the cell b
going to Format>cells>custom and type in the type tab [hh]:mm
this will give you the correct answer


regards Howar
 
S

Sasa Stankovic

It is very easy:
Select cell with sum function and use Format->Cells>Number tab and use
Custom option.
Enter [HH]:mm and it will summarize over 24h limit...

sasa stankovic
 
F

faerk

Thanks - but - as a novice in spreadsheets - and bc my spreadsheet is i
danish Language, I hav'nt been able to act. the way you recommended (since
all here is in danish!

"Sasa Stankovic" skrev:
It is very easy:
Select cell with sum function and use Format->Cells>Number tab and use
Custom option.
Enter [HH]:mm and it will summarize over 24h limit...

sasa stankovic So, I'm sorry, it's not so easy for me!

Can I "beg" you to be a bit more specific -

best frm Faerk
 
P

Peo Sjoblom

First of all since you are using *24 you should format it as general or a
number and not time, if you which you seem to have done you will get
32.833333 which is correct. If you format as
[tt]:mm (I am using Swedish format, I am assuming Danish format is similar)

Then you should get 32:50 which equals 32.833333,
32:30 equals 32.50 in decimal time


--


Regards,


Peo Sjoblom





faerk said:
Thanks - but - as a novice in spreadsheets - and bc my spreadsheet is i
danish Language, I hav'nt been able to act. the way you recommended (since
all here is in danish!

"Sasa Stankovic" skrev:
It is very easy:
Select cell with sum function and use Format->Cells>Number tab and use
Custom option.
Enter [HH]:mm and it will summarize over 24h limit...

sasa stankovic So, I'm sorry, it's not so easy for me!

Can I "beg" you to be a bit more specific -

best frm Faerk
 
F

faerk

Thanks to you both!
I must be extraordinary dum, since I cant follow your reciepts.

Where do I put the "[TT]:mm" like this? =SUM(C6:C19)[24]:60, or like this:
=SUM(C6:C19)[TT]:mm, or?

regards

Faerk

"Peo Sjoblom" skrev:
First of all since you are using *24 you should format it as general or a
number and not time, if you which you seem to have done you will get
32.833333 which is correct. If you format as
[tt]:mm (I am using Swedish format, I am assuming Danish format is similar)

Then you should get 32:50 which equals 32.833333,
32:30 equals 32.50 in decimal time


--


Regards,


Peo Sjoblom





faerk said:
Thanks - but - as a novice in spreadsheets - and bc my spreadsheet is i
danish Language, I hav'nt been able to act. the way you recommended (since
all here is in danish!

"Sasa Stankovic" skrev:
It is very easy:
Select cell with sum function and use Format->Cells>Number tab and use
Custom option.
Enter [HH]:mm and it will summarize over 24h limit...

sasa stankovic So, I'm sorry, it's not so easy for me!

Can I "beg" you to be a bit more specific -

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

faerk

- assuming your formula =Sum(A1:A6) is in cell A7 format the cell by going
to Format>cells>custom and type in the type tab [hh]:mm
this will give you the correct answer...

Ok, but since my Spreadsheet is in Danish lang, I dont know where to find
this tab.

Again... can I Write like this: =SUM(C6:C19)[hh]:mm, or will one of you
send me a screenshot or two, to: efaerk(at)gmail.com, so I can compare your
versions tabs a.s.o. with my Danish version, please?

Regards Faerk


"gearcutter" skrev:
faerk;710496 said:
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)

Hi Faerk
assuming your formula =Sum(A1:A6) is in cell A7 format the cell by
going to Format>cells>custom and type in the type tab [hh]:mm
this will give you the correct answer


regards Howard
 
F

faerk

Hurrah - I got it - [HH]:mm in english is = [TT]:mm in Danish :) as "Peo
Sjoblom" wrote.

Thanks to all of you :)

Best regards frm. Faerk

"Peo Sjoblom" skrev:
First of all since you are using *24 you should format it as general or a
number and not time, if you which you seem to have done you will get
32.833333 which is correct. If you format as
[tt]:mm (I am using Swedish format, I am assuming Danish format is similar)

Then you should get 32:50 which equals 32.833333,
32:30 equals 32.50 in decimal time


--


Regards,


Peo Sjoblom





faerk said:
Thanks - but - as a novice in spreadsheets - and bc my spreadsheet is i
danish Language, I hav'nt been able to act. the way you recommended (since
all here is in danish!

"Sasa Stankovic" skrev:
It is very easy:
Select cell with sum function and use Format->Cells>Number tab and use
Custom option.
Enter [HH]:mm and it will summarize over 24h limit...

sasa stankovic So, I'm sorry, it's not so easy for me!

Can I "beg" you to be a bit more specific -

best frm 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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top