Number conversion to Hours

[JR]

Hello,

Can someone tell me how I would take 79.5 (formatted as general) and convert
it to time 79:30. Thanks

[Roger Govier]

Hi

Excel stores times as fractions of a day, so in an adjacent cell, so
assuming you have 79.5 in A1
enter =A1/24


--
Regards

Roger Govier


"JR" <JR@discussions.microsoft.com> wrote in message
news:CDB2A280-16EC-452D-8857-7D487097E033@microsoft.com...
> Hello,
>
> Can someone tell me how I would take 79.5 (formatted as general) and
> convert
> it to time 79:30. Thanks

[bpeltzer]

Divide by 24 then format the result as [h]:mm (Format > Cells, click the
Number tab, select Custom and enter that format string in the text box)

"JR" wrote:

> Hello,
>
> Can someone tell me how I would take 79.5 (formatted as general) and convert
> it to time 79:30. Thanks