Convert hours to minuets

[RJL]

Is there a way to convert hours and minuets to just minuets.

ie: 1:06 = 66

[Bob Phillips]

=A1*24*60 and format as General

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"RJL" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to convert hours and minuets to just minuets.
>
> ie: 1:06 = 66

[CLR]

If the 1:06 is actually a TEXT value, then use this........

=(LEFT(A1,FIND(":",A1,1)-1)*60)+(RIGHT(A1,2)*1)

Vaya con Dios,
Chuck, CABGx3



"RJL" wrote:

> Is there a way to convert hours and minuets to just minuets.
>
> ie: 1:06 = 66