DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
minutes
|
|
|
money
|
|
|
months
|
|
|
moments
|
Detailed explanation-1: -In the Format Cells dialog box, click the Number tab. Under Category, click Custom. In the Type box, type [h]:mm. TIP You can also show the results in minutes and seconds by setting the format to [m]:ss, or minutes only by typing [m].
Detailed explanation-2: -Right click the selected cells and then click Format Cells, or press Ctrl + 1. This will open the Format Cells dialog box. On the Number tab, under Category, select Custom, and type one of the following time formats in the Type box: Over 24 hours: [h]:mm:ss or [h]:mm.
Detailed explanation-3: -Divide the minute value by 1440 ( A1/1440 ). Format the value as “Time".
Detailed explanation-4: -In the Format Cells box, click Custom in the Category list. In the Type list, click h:mm (for hours and minutes), and then click OK.