Summing cells defined as Time hh:mm

[Guest]

I looked at a couple of similar questions but have not been able to achieve a
good result.

I have a few cells defined as Time HH:MM. I want to sum them up so I get
hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)". I
formatted the Total cell as custom with a format of [hh]:mm. The original
values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am
getting is 577:00

Which is funny, but not very useful.

Can you help, Ed

 

[Guest]

Make sure you don't have an AM/PM problem. If you format your cells as
General you should see:

0.416666667
0.125
0.5
1.041666667

 

[David Biddulph]

I looked at a couple of similar questions but have not been able to achieve
a
good result.

I have a few cells defined as Time HH:MM. I want to sum them up so I get
hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)".
I
formatted the Total cell as custom with a format of [hh]:mm. The original
values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am
getting is 577:00

What values are in the other 2 cells? N43 to N47 are 5 cells; you've
quoted 3 values. Are the other 2 empty?

 

[Guest]

They are indeed empty.

I looked at a couple of similar questions but have not been able to achieve
a
good result.

I have a few cells defined as Time HH:MM. I want to sum them up so I get
hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)".
I
formatted the Total cell as custom with a format of [hh]:mm. The original
values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am
getting is 577:00

What values are in the other 2 cells? N43 to N47 are 5 cells; you've
quoted 3 values. Are the other 2 empty?

 

[Guest]

Set them to 0:00 with no difference. Also set them to 1:00 with no difference.

I looked at a couple of similar questions but have not been able to achieve
a
good result.

I have a few cells defined as Time HH:MM. I want to sum them up so I get
hours and minutes. In the cell to hold the total, I used "=SUM(N43:N47)".
I
formatted the Total cell as custom with a format of [hh]:mm. The original
values were 10:00, 3:00, 12:00. I was expecting to get 25:00. What I am
getting is 577:00

What values are in the other 2 cells? N43 to N47 are 5 cells; you've
quoted 3 values. Are the other 2 empty?