Lyrics & Knowledge Personal Pages Record Shop Auction Links Radio & Media Kids Membership Help
The Mudcat Cafemuddy

Post to this Thread - Sort Descending - Printer Friendly - Home


Tech: Song timings in MS Excel

Weasel 14 Mar 16 - 06:11 AM
GUEST,Howard Jones 14 Mar 16 - 06:20 AM
Weasel 14 Mar 16 - 06:39 AM
Mr Red 15 Mar 16 - 04:08 AM
Will Fly 15 Mar 16 - 08:44 AM
Share Thread
more
Lyrics & Knowledge Search [Advanced]
DT  Forum
Sort (Forum) by:relevance date
DT Lyrics:





Subject: Tech: Song timings in MS Excel
From: Weasel
Date: 14 Mar 16 - 06:11 AM

Hi,

I'm creating a database of song details and want to include timings. How do I format this field in MS Excel? Formatting it as "time" converts it all to actual times rather than length of time and ordinary format seems to treat it as base ten rather than seconds and minutes.

Cheers,

Weasel


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Song timings in MS Excel
From: GUEST,Howard Jones
Date: 14 Mar 16 - 06:20 AM

Google says:

http://new.office-watch.com/2015/entering-time-durations-in-excel/


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Song timings in MS Excel
From: Weasel
Date: 14 Mar 16 - 06:39 AM

Thanks, I'd looked in Excel help to no avail and also google but clearly used incorrect terminology.

Thanks again.

Weasel


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Song timings in MS Excel
From: Mr Red
Date: 15 Mar 16 - 04:08 AM

If you webmail me from mister.red - start a conversation, better than here. I might need more detail, re what is meant by "time". I am sure I could help. If not in cell formulae then in a macro. Be sure to include Weasel-Excel in the subject and I will spot it.

PS if you look at some of my lists, even dances, they are produced (yes the HTML) in Excel with cells and macros. I recently needed to find the duration of mp3s and found VBA code that allowed me to construct lists for StroudVoices.co.uk with duration and pointing to the tracks. I rarely fail when asking on techie forums.

There is always someone who knows something you don't!


Post - Top - Home - Printer Friendly - Translate

Subject: RE: Tech: Song timings in MS Excel
From: Will Fly
Date: 15 Mar 16 - 08:44 AM

One very simplistic way would be to create two columns for time duration - one for minutes and one for seconds - or three columns if you include hours.

Not clever but certainly easy.


Post - Top - Home - Printer Friendly - Translate
  Share Thread:
More...

Reply to Thread
Subject:  Help
From:
Preview   Automatic Linebreaks   Make a link ("blue clicky")


Mudcat time: 25 April 4:19 AM EDT

[ Home ]

All original material is copyright © 1998 by the Mudcat Café Music Foundation, Inc. All photos, music, images, etc. are copyright © by their rightful owners. Every effort is taken to attribute appropriate copyright to images, content, music, etc. We are not a copyright resource.