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