Media Player to Excel Conversion p2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is the fact that the 7[h]: 38[mm]:46[ss] is close to the actual
7:38 mm:ss of the song duration. Is there any way Excel can show a duration
of time without associating this time with a date? If so how?

If not there should be a way to associate a time druation that in NOT
attached to a speciffic date! From the amount of posts, I think this has
become concern to many users! Maybe some one can write a fix, if we live that
long!
 
Rino

I just exported my library (MP10) to Excel 2003 and with a simple formula of

=((G2/24)/60)/60

(G2 is the imported time 'number'), came up with the correct playtimes, when
formatted as a time

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Thanx Nick; I'll give it a try. If you don't hear back from me its because
I'm puttung the new equation in my spreedsheet!


Nick Hodge said:
Rino

I just exported my library (MP10) to Excel 2003 and with a simple formula of

=((G2/24)/60)/60

(G2 is the imported time 'number'), came up with the correct playtimes, when
formatted as a time

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Rino said:
My problem is the fact that the 7[h]: 38[mm]:46[ss] is close to the actual
7:38 mm:ss of the song duration. Is there any way Excel can show a
duration
of time without associating this time with a date? If so how?

If not there should be a way to associate a time druation that in NOT
attached to a speciffic date! From the amount of posts, I think this has
become concern to many users! Maybe some one can write a fix, if we live
that
long!
Click to expand...
Click to expand...
 
Rino

You only need enter it once and double click the fill handle to complete the
other x rows

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Rino said:
Thanx Nick; I'll give it a try. If you don't hear back from me its because
I'm puttung the new equation in my spreedsheet!


Nick Hodge said:
Rino

I just exported my library (MP10) to Excel 2003 and with a simple formula
of

=((G2/24)/60)/60

(G2 is the imported time 'number'), came up with the correct playtimes,
when
formatted as a time

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Rino said:
My problem is the fact that the 7[h]: 38[mm]:46[ss] is close to the
actual
7:38 mm:ss of the song duration. Is there any way Excel can show a
duration
of time without associating this time with a date? If so how?

If not there should be a way to associate a time druation that in NOT
attached to a speciffic date! From the amount of posts, I think this
has
become concern to many users! Maybe some one can write a fix, if we
live
that
long!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top