mm:ss format problem
See attached. Col C contains song length in mm:ss: it imported from a pdf that way.
I copied C to D and set Format Cells to mm:ss: now numbers get interpreted as hh:mm, for display. Format as shown in data entry area is hh:mm:ss AM.
Puzzling. I can solve the problem by adding 0: to the front of each length, because I then have h:mm:ss.
|