Media Info Exporter - Convert Track length to mm:ss
- By Ramesh Srinivasan
- Published
Q: I've installed Media Info Exporter from the Winter fun pack (Microsoft). When I export my song list to Word or Excel the track length is in seconds. I want to convert the seconds to mm:ss format, like it displays in Windows Media Player. How do I do that?
A: I'm not sure if this setting is configurable in Media Info Exporter plug-in options, but you can accomplish this using Formula in Microsoft Excel, or perhaps by writing a Macro. Here is a Macro that should do the task:
Sub Macro1()
Dim rng As Range, cell As Range
Set rng = Range("g2:g50")
For Each cell In rng
If cell.NumberFormat = "General" Then
cell.Value = cell.Value / 86400
cell.NumberFormat = "mm:ss"
End If
Next
End Sub
Dim rng As Range, cell As Range
Set rng = Range("g2:g50")
For Each cell In rng
If cell.NumberFormat = "General" Then
cell.Value = cell.Value / 86400
cell.NumberFormat = "mm:ss"
End If
Next
End Sub
FYI: Column G contains the Track Length, and this script takes the cell range G2:G50. If you have too many lines, you may have to modify the cell range in Macro accordingly.
