Need help adding hours exceeding 24 hours

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

 

[gearcutter]

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

 

[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

 

[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

 

[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

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

 

[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

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)

 

[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:

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

 

[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

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)