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 shown below.
2. Select cells B4:B8 and then enter the following formula: =A4*24*60.
3. Press Ctrl+Enter.
4. Format cells B4:B8 as general by selecting the Format menu and choosing Cells and General then clicking OK.

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 above.