problem with summing

=SUMPRODUCT(--(LEFT("00:00:00",8-LEN(A1:A10))&A1:A10))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cs78 via OfficeKB.com" <u14879@uwe> wrote in message
news:55d04ccffbec0@uwe...
> Hi everyone,
>
> I'm having problems summing up a range of values. It's supposed to be time
> but because the range of data was copied over from another program, 30
> seconds would be displayed as ":30".
>
> I've tried auto adding a "0" or "00" in front of it and changing the
formats
> to mm:ss but the sum of the range of figures still comes up as 00:00.
Anyone
> knows how I can go about summing up the total amount of time? Thanks!

It worked perfectly, thanks so much for your help!

Bob Phillips wrote:
>=SUMPRODUCT(--(LEFT("00:00:00",8-LEN(A1:A10))&A1:A10))
>
>> Hi everyone,
>>
>[quoted text clipped - 5 lines]
>> to mm:ss but the sum of the range of figures still comes up as 00:00. Anyone
>> knows how I can go about summing up the total amount of time? Thanks!