Split minutes and seconds

Copper Contributor
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 !!!!
0 Replies