Convert from hours to minutes - Formulas In Excel - Microsoft Excel Tutorials

5.  Convert from hours to minutes

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.

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 - https://www.youtube.com/watch?v=HajulaXpweU

 

Hope You Like This Tutorial - Give Comments