Are you certain you have those cells formatted as TIME and not as text? I
just set up 3 cells formatted as Time using the 13:30 format shown in the
format picker as:
3:12
6:18
9:30
and then below them put
=Sum(A1:A3) and got the expected 19:00 result. But in 3 other cells
formatted as Text, the result was also my expected 0 (zero).


"Champ" wrote:

I have read a bunch of the previous questions, none seem to finish what I need.

I have 4300 cells, in a single column,all with times formatted as shown:
[hh]:mm, or represented as: 03:12; 3-hours, 12-minutes. I tried to add the
times as follows: sum(m2:m4300) which keeps adding into 0. Does anyone have
a way to add these in the sum block without having to do this:
sum(m2+m3+m4+m5) all the way to m4300. Any thoughts? Thanks in advance.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc