Convert decimal number into hours and minutes

  • Thread starter Thread starter Gabriel Maraqa
  • Start date Start date
G

Gabriel Maraqa

Dear newsgroup members

How can I convert a decimal number (for ex. 32.01667) into
a time format that loks like HH:MM (for the example it
should return 32:01). Any help is greatly appreciated.

Kind regards

Gabriel
 
Hi Gabriel
try
=TIME(INT(A1),ROUND(A1-INT(A1),2),0)
if A1 stores your decimal number
 
Back
Top