time:how can i convert "22 hours 23 minutes" into 22:23 ?

how can i convert "22 hours 23 minutes" into 22:23 ?

Hi Gary,

One way is to use Text to Columns so that in your example
you would have,

A1 B1 C1 D1
22 hours 23 minutes

then in E1 put =A1&":"&C1

Depending on your setup it maybe better to export it to
a blank sheet for the conversion and then import back
to your original.

HTH
Martin

Thanks Martin,

But is it possible to convert 22 Hours 23 Minutes dierctly in to 22:23 ?

"MartinW" <mtmw@hotmail.invalid> wrote in message
news:OvjUCdttGHA.476@TK2MSFTNGP06.phx.gbl...
> Hi Gary,
>
> One way is to use Text to Columns so that in your example
> you would have,
>
> A1 B1 C1 D1
> 22 hours 23 minutes
>
> then in E1 put =A1&":"&C1
>
> Depending on your setup it maybe better to export it to
> a blank sheet for the conversion and then import back
> to your original.
>
> HTH
> Martin
>

=(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 ?
>
>

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 ?
>>
>>
>
>