Forum Discussion
Pradeep_K
Apr 04, 2019Copper Contributor
Split minutes and seconds
Hi there, I've got 75 odd audio files each having duration in the form of m:s.
For e g 12.29, 23.24, 5.67, 7.65, 32.12, etc.
I can get the minutes out of these in a separate column by rounding them up. Any idea how can I get the seconds in a separate column. I want to total minutes and seconds separately after splitting them up. Thanks !!!!
For e g 12.29, 23.24, 5.67, 7.65, 32.12, etc.
I can get the minutes out of these in a separate column by rounding them up. Any idea how can I get the seconds in a separate column. I want to total minutes and seconds separately after splitting them up. Thanks !!!!
No RepliesBe the first to reply