Not showing time correctly

krypton80

New member
Joined
Nov 28, 2013
Messages
1
Reaction score
0
Points
0
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

Thanks in advance
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Perhaps?

=TIME(0,HOUR(A1)+24*DAY(A1),MINUTE(A1))

copied down

assuming first time is in A1.
 
Top