Select one or more cells that contain a decimal-based time value. Launch the Format Cells dialog box. A keyboard shortcut for doing so is Ctrl-1. On the Number tab choose Custom. Scroll down the list of custom formats and choose h:mm, and then click OK. ...
Convert decimals to minutes. To convert time expressed in decimals back to minutes you will simply take the decimal portion of the number, i.e. just the digits to the right of the decimal point, and multiply it by 60 (minutes in an hour). For example, if you have 1.45 hours, then take .45X60. This gives you 27.
To convert hours into minutes, take the number of hours and multiply them by 60 to get the total number of minutes. This is possible because there are 60 minutes in one hour.
Convert hours to minutes with this simple formula: minutes = hours × 60. Converting a hour time measurement to a minute measurement involves multiplying your time by the conversion ratio to find the result. A hour is equal to 60 minutes, so to convert simply multiply by 60. For example: 5 hr = (5 × 60) = 300 min.