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.