covert 72.8 to 72:48

R

Rosemary

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
B

Bernie Deitrick

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
 
Top