=(LEFT(A11,FIND(" ",A11))+MID(A11,FIND("s ",A11)+2,FIND(" ",A11,FIND("s
",A11)+2)-FIND("s ",A11)-2)/60)/24

and format as hh:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" <gaurav_ss@hotmail.com> wrote in message
news:eLpddUttGHA.3568@TK2MSFTNGP05.phx.gbl...
> how can i convert "22 hours 23 minutes" into 22:23 ?
>
>