Convert hours to minuets
 

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

ie: 1:06 = 66

Convert hours to minuets
 

=A1*24*60 and format as General

--

HTH

Bob Phillips

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

"RJL" wrote in message
...
Is there a way to convert hours and minuets to just minuets.

ie: 1:06 = 66

Convert hours to minuets
 

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