How to calculate minutes from value ?

Hi all,

I have the following data entered by the user which the decimal point onward is represent minutes and now I need to convert that into actual hour and minute for my other calculation. How am I going to do that ?

E.g of my data will be 1098.890 where the 890 is represent minute and I need to convert 890 into minutes mean 890/60 = 14.8333 and the result of 14 I need to add with 1098 + 14 = 1112 and the remaining 8333 will be added to the minutes. How am I going to do ?

Please guide me. Thanks.

Regards,
Lim

Hi

If your data is in A1 then try

=INT(A1) +INT((A1-INT(A1))*1000/60)

This will give you the 1112 result, but I'm not really sure what you want to do with the 8333. Do you really want to add it to 1112 resulting in 9445??

rylo