Convert decimal number into hours and minutes

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
 
F

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Convert a decimal time to hours and minutes 2
Convert decimal days to hours and minutes 2
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m 1
how to convert total hours (HH:MM) into decimal number 1
Converting a number to hours and minutes 4
Convert decimal hours to hours:minutes 5
Convert Decimal hours and Minutes to minutes please. 13
Converting a decimal time into hours and minutes 1

Top