Format the Time

5. Try it: Format the Time

Select Column L.

Go to Home->Number->More.

(the little arrow in the bottom right corner)

 

 

Go to the Number Tab.

Select the Custom Category.

Choose: h:mm

 

6. What Do You See? The Duration will be formatted as Hours and Minutes.

 

Save Your Spreadsheet.

Very good.

Home->Number->More

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.6. Create and apply cell styles: Apply Custom Format