I hope this is an easy one...

I have data that spits out times in a text format that usually appear as
:mm:ss (zero hours are omitted), but in the rare chance it goes over 60min,
it appears as h:mm:ss. How do I account for the varying digit(s) for the
hours when using
TIME(hh,mm,ss)? The time starting with the ":" throws a monkeywrench into my
formulas...

I got it to work for anything under an hour using:
TIME(0,RIGHT(LEFT(A1,3),2),RIGHT(A1,2)), but when its greater than 60min, it
doesn't work (obviously since theres a zero in the hour field).