Forum Discussion
Need to calculate minutes and seconds
Hi, I am trying to work out how to calculate minutes and seconds to help plan play lists for my radio programme but am unable to fathom it out. Here is what I want to do: Track 1 3...
Excel always considers time in Hours:Minutes:Seconds and you can't change that. But you may interpret hours as minutes and minutes as seconds. One variant is apply custom format (Ctrl+1) on cell as
h:mm "("h "mins" mm "secs)"but it assumes your tracks are not more than 24 minutes. Another variant is to split on two columns and use elapsed time format
Same is in attached file.