covert 72.8 to 72:48
On Tue, 10 Oct 2006 06:08:01 -0700, Rosemary
wrote:
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
That depends on what you want to do with the value.
Basically, you divide by 24 and format the result as Format/Cells/Number/Custom
Type: [h]:mm
That would give a value that Excel would recognize as time.
You could also use the formula:
=TEXT(A1/24,"[h]:mm")
which would give a text string.
--ron
|