how do type in the playing time of tracks on a cd, in excel

F

ferrarigirl

I am keeping track of my mp3 files & want to know how to enter the track
length. It shows up as a time of the day at the moment.
 
G

Gizmo63

Set your format to mm:ss
(I doubt you need the hour field for modern music!)

Then enter your time as 0:3:20 for a 3 min 20 track - NOTE you must enter a
zero for the hours even if you're not showing it.

HTH

Giz
 
Top