XL stores times as fractional days. So to convert to hours, enter 24 in
a blank cell. Copy the cell. Select the cells with your times, and
choose Edit/Paste Special, selecting the Values and Divide radio
buttons. Click OK.

Format as times.

In article ,
mailrail wrote:

One of my data sheets at work brings numbers into Excel as decimals. For
instance, 5 hours and 39 minutes is shown as 5.39. How can I get Excel to
convert this to 5:39 (semicolin instead of decimal)?