View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ravi B Ravi B is offline
external usenet poster
 
Posts: 2
Default using time data copied and pasted into excel from external source

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