Sum for column containing colons (:)

C

/CD/

I am trying to add a column of numbers with colons in them. They are call
minutes in a cell phone bill such as 6:00, 12:00, etc.

When I use the SUM formula, I get an error "the formula you typed contains
an error".

How can I add this column to get total minutes of usage?

Don
 
P

Peo Sjoblom

And you didn't think it would be a good idea to post the formula that
returns this error?
 
K

Ken Wright

From what I can see I'd guess either the first / middle or end part of the
formula is wrong. :)

Seriously though, as the other have said, post the formula. Just one thought
though - Are those real times, or is it text in those cells. If you click into
one of those cells, do you actually see the colon in the formula bar? If so
this is not good :) Hopefully they really are numbers formatted as times, but
we need more info.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of minutes and seconds times price? 2
Time Sum in Excel 1
help with formula 3
How can I Sum time duration? 1
Offset, Match Questiond 7
Subtracting hours and minutes with negative times 3
Excel 2013: AutoFilter and SUM() 1
Sumproduct Help! 3

Top