How to convert XXh XXm XXs into simple number?

**jenli17** · 09-15-2009, 07:59 AM

Hello,

Hope someone can help me out.
Possibly might be easy, but I am trying to convert wrap up time in excel from the format Xh Xm Xs where "X" is the number, to showing only numbers no text.

So then I can format it to count "1" if it is less then 40sec for example.

Thanks

**sweep** · 09-15-2009, 08:10 AM

Hi,

This

=TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"h",":"),"m",":"),"s",""))

will convert your data into a format that excel recognises as a time, and can handle.

Is this what you need?