Excel is not seeing the values as h:mm:ss because there are too many digits
in mm. It is seen as text. The formula below will do your calculation, but
the result will again be text.

=VALUE(MID(A1,3,LEN(A1)-5))+VALUE(MID(A2,3,LEN(A1)-5))&":"&VALUE(RIGHT(A1,2))+VALUE(RIGHT(A2,2))

This assumes your original data is in A1 & A2

--
Ian
--
"eacollins" wrote in message
...
I'm trying to total a column with large minute values. For example, I want
to add 0:1125325:27 (1,125,325 minutes, 27 seconds) with 0:2358964:18
(2,358,964 minutes, 18 seconds. My total column shows as 00:00, no matter
how I play with the format. I have the individual times formatted as
h:mm:ss, and I have the total column formatted as [mm]:ss so the results
will
stay in minutes. However, it's almost like I need to have h:mmmmmmm:ss and
[mmmmmmmm]:ss. However, that's not working for me. If I try to create
h:mmmmmmm:ss, Excel saves it as h:mmmm:ss, and then it reads the 'm' as
month instead of minute. I'm not getting anywhere. If anyone knows how to
make
this work, I would really appreciate it.

Thank you!