Correction:
Use this Macro instead. Works flawlessly.
- - -
Sub macro1()
Dim rng As Range, cell As Range
Set rng = Range("g2:g26")
For Each cell In rng
If cell.NumberFormat = "General" Then
cell.Value = cell.Value / 86400
cell.NumberFormat = "mm:ss"
End If
Next
End Sub
- - -
--
Regards,
Ramesh Srinivasan, Microsoft MVP [Windows XP Shell/User]
Windows® XP Troubleshooting
http://www.winhelponline.com
Not sure if the Media Info Exporter can be configured that way, but you can
format the info in the Excel sheet by using the Formula (divide the value by
60), or by writing a macro. Here is what I came up with quickly:
- - -
Sub Macro1()
Dim rng As Range, cell As Range
Set rng = Range("g2:g50")
For Each cell In rng
cell.Value = cell.Value / 60
cell.NumberFormat = "0.00"
Next
End Sub
- - -
Running this macro divides the existing cell value by 60 (seconds) and then
sets the number format to 2 decimal places. See Microsoft Excel help page to
know how to execute a Macro.
--
Regards,
Ramesh Srinivasan, Microsoft MVP [Windows XP Shell/User]
Windows® XP Troubleshooting
http://www.winhelponline.com
Hi all.
I've got WMP 10 with the Media Info Exporter from the Winter fun pack.
When I export my song list to Word or Excel the track lenght is in
seconds. I want to keep is as mm:ss ;ike it displayes in WMP. Any
ideas? thanks.
