EXCEL formula help

[roger68]

I have an Excel sheet where one column contains a time in the following format: 0000:00:32. I am trying to come up with a formula that will delet all of the zeros so that time will read as 32. I've tried everything and haven't had any luck yet. It's not as simple as just reformatting the cell. Any ideas?

FYI, I am using EXCEL 2007.

 

[VoG]

Does this work?

=SECOND(A1)

 

[roger68]

No, it doesn't. I had tried that previously. When I enter =SECOND(A1), I get #VALUE!

 

[alansidman]

What is the format for the cell containing 0000:00:32
Alan

 

[alansidman]

Did you try =right(Celladdress,2). I tried this when and it returned 32 with the original cell formatted as general.

Alan

 

[roger68]

Thanks, Alan! You are the man! It worked beautifully! Geez, something so simple that I have been pulling my hair out for 3 days now..... I do appreciate it!