Forum Discussion
adding mintues and seconds from songs to add to a cd from excel 365
I am trying to create a cd with mp3 files. I want to use excel 365 which I just renewed last week. I need to add up the minutes and seconds so as not to exceed the 80 min. allowed. thank you from anyone.
steve high
1 Reply
stevehigh Perhaps the attached file helps in solving your problem. It accumulates the time in "hh:mm:ss" format for all tracks in the list and uses conditional formatting to flag when the accumulated time exceeds 1 hour and 20 minutes (=80 minutes).
