put 60 in an empty cell
Edit|copy that cell
Select the range to fix
Edit|paste special|divide

You may want to reformat the cells to something like:
hh:mm:ss

Or you could just fix the cell with the total:
=sum(yourrangehere)/60

ps. You can use this format to show the total in minutes and seconds:
[mm]:ss
or
[hh]:mm:ss
to see the total in hours, minutes and seconds.



Ravi B wrote:

I am trying to add time duration of song tracks together with information
that was copied and pasted into excel from iTunes. The song length is in
format 04:33 meaning 4 mins and 33 seconds. In trying to sum several song
lengths together it becomes clear that excel is reading this 04:33 as 4 hours
and 33 minutes which gives very peculiar results if you are looking for total
running times for various groups of songs. How do I get excel to recognise
this copied data as minutes and seconds rather than hours and minutes. In
trying to format the cells to minutes and seconds it changes the values, I do
not want this.

Please Help!

Thanks in Anticipation
--
Ravi B

--

Dave Peterson