14 Mar 16 - 06:11 AM (#3778728) Subject: Tech: Song timings in MS Excel From: Weasel 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 |
14 Mar 16 - 06:20 AM (#3778730) Subject: RE: Tech: Song timings in MS Excel From: GUEST,Howard Jones Google says: http://new.office-watch.com/2015/entering-time-durations-in-excel/ |
14 Mar 16 - 06:39 AM (#3778734) Subject: RE: Tech: Song timings in MS Excel From: Weasel Thanks, I'd looked in Excel help to no avail and also google but clearly used incorrect terminology. Thanks again. Weasel |
15 Mar 16 - 04:08 AM (#3778917) Subject: RE: Tech: Song timings in MS Excel From: Mr Red 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! |
15 Mar 16 - 08:44 AM (#3778974) Subject: RE: Tech: Song timings in MS Excel From: Will Fly 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. |