Thank You - although #Value error as demical data is 39:83 not 39.83.

Do I need to convert 39:83 to 39.83 first?? If so, can you help me ?

Thanks again
Rachel



"CLR" wrote:

This will return 39.50
=INT(A1)&":"&(TEXT((A1-INT(A1))*100*0.6,"00"))


This will return 39.49
=INT(A1)&":"&(TEXT(ROUNDDOWN((A1-INT(A1))*100*0.6,0),"00"))

Vaya con Dios,
Chuck, CABGx3



"RachelB" wrote:

For example I have 39:83. I want to convert to 39:49

I want to only convert the :83 decimal into minutes.

I am using the =text(value/24, "h:mm") but this is converting 39:83 to 13.49.

Please can anyone help ?
Thanks