graphic2
graphic1
 

Exam 77-427 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.1 Apply Custom Data Formats: Create Custom Formats (Number, Time, Date)

Format the Time

5. Try it: Format the Time

Select Column L.

Go to Home->Number->Number Format.

(the little arrow in the bottom right corner)

 

graphic4

 

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->Number Format
graphic3