Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Duration problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
geewhizza - 30 Oct 2006 11:18 GMT
Recently to avoid cd buying duplication  i started to create a excel
database of my audio cd collection , artist, track,cd name, duration of each
track etc.

I am now about half the way through my cd database and have just started
using a little program that gets me the track info from gracenote which i
then copy and paste into excel the problem is...

The track duration isnt copying the same as it is being displayed for
example this is how it should be

M People - Moving On Up - Funky Divas cd 2 - 3:30
Is appearing in Excel as

But this is how it is in excel

M People - Moving On Up - Funky Divas cd 2 - 210

any ideas

Thanks...
Bob Phillips - 30 Oct 2006 11:32 GMT
It is showing the time in minutes, you need to divide by 86400 and format

TEXT(playtime/86400,"mm:ss")

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Recently to avoid cd buying duplication  i started to create a excel
> database of my audio cd collection , artist, track,cd name, duration of each
[quoted text clipped - 22 lines]
>       ------->>>>>>http://www.NewsDemon.com<<<<<<------
> Unlimited Access, Anonymous Accounts, Uncensored Broadband Access
Ron Rosenfeld - 30 Oct 2006 12:27 GMT
>It is showing the time in minutes, you need to divide by 86400 and format
                          ^^^^^^^
                          seconds

>TEXT(playtime/86400,"mm:ss")

--ron
geewhizza - 30 Oct 2006 17:26 GMT
Thanks for the replies...much appreciated!.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.