Hi!
i would appreciate any help on this as I have spent a great deal of time on this. I have a whole set of excel sheets with the following information pertaining to audio files
No Filename Duration
The durations have all been entered as 1.29, 32.31, 102.11 etc with the number before the decimal point indicating the minutes and the number after the decimal point indicating seconds(all formatted as general, which means that where the seconds is 20, it will display without the zero, such as 11.2, 10.3 etc)
I need to total the duration column, with the final display also showing in this same format and for teh life of me have not been able to do so. had the files been formatted better, with the minutes and seconds in separate columns, it would have been much easier, but right now i need to work with what i have.
would appreciate any help on this and also if you could point me out a better solution for this in future
Regards,
Sid
Bookmarks