Rosemary,

If the value is in cell A1, use

=A1/24

and format the cell with the formula for a custom number format of [h]:mm.

HTH,
Bernie
MS Excel MVP


"Rosemary" wrote in message
...
what is the formula to convert a time that is hours and decimal of hours to
hours and minutes for instance 72.8 to 72:48