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