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