I am trying to take a whole number and decimal and convert to minutes. Production numbers are displayed on report as 1.41 where 1 is 60 minutes, and .41 is 41 minutes. In this example I would need a calculation to translate the 1.41 to 101 minutes. Any suggestions???
Andy Brown - 21 Jan 2004 00:39 GMT
>> Any suggestions???
=(INT(A1)*60)+((A1-INT(A1))*100)
HTH,
Andy
afuleki - 21 Jan 2004 02:11 GMT