convert number to hh:mm

G

Guest

I have a calculation returns the value of 26.4 - which is actually 26 hours
and 24 minutes. What formula would I need to use to use the hh:mm format and
return 26:24.
Thanks so much!!!
 
V

vezerid

=A1/24
If you want a display like 26 hours, you will need the [hh]:mm Custom
format.

HTH
Kostis Vezerides
 

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

Adding Times 7
how to convert total hours (HH:MM) into decimal number 1
How to get timein hh:mm format 3
Converting decimals into hh:mm 4
calculate cells with format hh:mm 4
Can I convert hh:mm to mm in Excel 1
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m 1
converting to time format 6

Top