Excel 2007 : Convert 7H 10S to HH:MM:SS format in Excel

**pappu07** · 06-03-2011, 10:44 AM

Hi,

I have time in the below format in a cell and convert the time into HH:MM:SS format. Can you please let me know how I can do it? Please help me with this.

Format:

7H 10S convert to --> 7:00:10
10H 30M 05S convert to --> 10:30:05

**MarvinP** · 06-03-2011, 11:44 AM

Hi pappu07,

I'm so close but don't have the correct formulas for 2003. I'm hoping you are really using 2007 or above. I've done the formulas using (new to 2007) a =IfError function. If you can convert this to the older 2003 formula using http://www.excelfunctions.net/Excel-Iferror.html I believe you will have an answer.

Here are the attached to work on.

Perhaps someone with 2003 can convert the IFError for us.

**pappu07** · 06-03-2011, 11:54 AM

Thanks a lot for the quick response.

I am using office 2007. I will check it and let you know.

Thanks again for your help...!!!

**MarvinP** · 06-03-2011, 12:00 PM

YEAH!
If you could change your profile to say 2007 it would have saved me lots of time failing at converting it to old 2003 functions. I never did convert it correctly.