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

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.

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

"ferrarigirl" wrote:

> 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.