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!