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)

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.