Thanks a ton Bob...u r amazing.

"Bob Phillips" <bob.NGs@somewhere.com> wrote in message
news:%23pOIRAutGHA.452@TK2MSFTNGP05.phx.gbl...
> =(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 ?
>>
>>
>
>