Thanks a ton Bob...u r amazing.

"Bob Phillips" wrote in message
...
=(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" wrote in message
...
how can i convert "22 hours 23 minutes" into 22:23 ?