Tech: Song timings in MS Excel

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.

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!

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

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/

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