Problem is - I know how to calculate this mannualy. But I need a function
that converts a decimal number of minutes ( for example , 1.59 ) to a time
format mm:ss (1:48)
Thank you for all your answers!
"Bob Phillips" wrote:
Divide it by 24 if it is hours, or by 1440 if it is minutes
--
HTH
Bob Phillips
"agenda9533" wrote in message
...
How to convert decimal number to time : convert 1,59 (minutes, dec) to
mm:ss
|