With 2.9 in cell A1

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

Change the cell format as needed.

"Excel Hack" wrote:

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

Cheers; Peter