CONVERT FROM HOURS TO MINUTES USING EXCEL FORMULAS

As a task, time in a timesheet has to be converted from hours to minutes.

To convert time to minutes:

1. In a worksheet, enter your own data or the data shown in Figure 1-5.
2. Select cells B4:B8.
3. Enter the following formula: =A4*24*60.
4. Press <-Ctrl+Enter->.

5. Format cells B4:B8 as general by selecting the Format menu and choosing Cells and General then clicking OK.

CONVERT FROM HOURS TO MINUTES USING EXCEL FORMULAS

Note: To convert minutes to hours and minutes format, use the formula =A4/24/60. Remember to format the cells with a time format, as shown in cell C4 in Figure 1-5.

Watch the Video Tutorial

Microsoft Excel Tutorials, Convert From Hours To Minutes Using Excel Formulas, Microsoft Excel Video Tutorials, How to use Macros in Excel