Maybe the stuff you're trying to add up isn't really time--maybe it's text
masquerading as time.

If one of your cells is A1, try putting this in an empty cell:

=isnumber(a1)

If this evaluates as False, then your times aren't times!

Maybe you can select the range of offending cells and
edit|replace
what: : (just the colon)
with: : (just another colon)
replace all

Maybe excel will reevalute those cells and see that they're really times.



Sweetpea60 wrote:

I also cannot get Excel to sum time. I used the formula [h]:mm but it did
not work -the number is still displayed as 1:05 AM (for example). I'm not a
whiz at Excel so need more help.

Thanks,

Patti

"Nick Hodge" wrote:

JDT

Format the cells to [hh]:mm through Formatcells...numbercustom

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"JDT" wrote in message
...
Hi,

I have a column with an amount of time entered. For ex:

1:38
2:05
3:00
0:45
6:27

etc.

When I try summing these time increments in another cell, the answer
is 0:00 if the total is over 24. I just need to be able to sum the
column and see how much total time there is--hours and minutes. I
know it's a simple solution.

Thanks.




--

Dave Peterson