G Guest Oct 10, 2006 #1 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
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 Oct 10, 2006 #2 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
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 Oct 10, 2006 #3 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, 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
