Hi all
I need help with times in excel 2010
I exported a list of mp3 durations, but the column shows minutes as hours.
For example, mp3 duration: 7 minutes and 30 seconds
in the csv exported files shows as 7:30:00
Plus, those mp3 with duration over 24 minutes, show also wrong
For example mp3 duration 27 minutes and 15 seconds
in the csv exported file shows as 01/01/1900 3:15:00
I would like them to show like this:
0:07:30
and
0:27:15
I have uploaded csv file if you want to take a look (42 KB)
Zippyshare.com - time.csv
Thanks in advance
I need help with times in excel 2010
I exported a list of mp3 durations, but the column shows minutes as hours.
For example, mp3 duration: 7 minutes and 30 seconds
in the csv exported files shows as 7:30:00
Plus, those mp3 with duration over 24 minutes, show also wrong
For example mp3 duration 27 minutes and 15 seconds
in the csv exported file shows as 01/01/1900 3:15:00
I would like them to show like this:
0:07:30
and
0:27:15
I have uploaded csv file if you want to take a look (42 KB)
Zippyshare.com - time.csv
Thanks in advance