converting hours to hours & minutes

Excel Hack · Nov 3, 2005

Hi, can anyone help me convert calculated hours (2.9) to display as Hours &
Minutes (2:54).

Cheers; Peter

JMB · Nov 3, 2005

With 2.9 in cell A1

=TIME(INT(A1),MOD(A1,1)*60,0)

Change the cell format as needed.

Biff · Nov 3, 2005

Hi!

Try this:

=(Yourformula(.......))/24

Format the cell as h:mm

Biff