Adding trouble in Excel

[J1mmy]

I am trying to add up a series of time duration, but excel doesn't come up with the right answer. I am sure I am inserting the correct formula. I have attached the file with the column that needs to be totalled..

[Steve R Jones]

Some food for thought.

Your cell A277 says-> 01:02:50

It's formated to be 2 minutes and fifty seconds past 1am.
Guessing that you'd like it it to be 1 minute and 2.5 seconds??

[J1mmy]

It's actually Hours:Minutes:seconds

So that would be 1 hour: 2 minutes: 50 seconds

[Steve R Jones]

Food for thought:
That number when rounded up would be 63 minutes and would be easier to work with.

[J1mmy]

No, I'm just not getting the right answer..

[jrsweger]

Sorry, I have to ask, what answer do you expect?

[jrsweger]

I think that your format of 00:00:01 may be invalid as a time in excel. Be removing the first 0 (zero) it works for me. I haven't edited all the cells yet to get the answer.

[jrsweger]

If you put this formula into B1 and copy it down to B277, then do a sum, I got 13:58:51. The formula I used is =VALUE(RIGHT(A1,7)). That way you don't have to take the 0 off the beginning of all of the cells.

[J1mmy]

Hmmm...

I'll take a look, isn't there a way to include those seconds? If not, then the next best answer should be okay.

[jrsweger]

Did this work or not? Just curious.