View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ravi B Ravi B is offline
external usenet poster
 
Posts: 2
Default getting excel to recognise copied data as mm:ss not hh:mm

I have copied track information from iTunes into Excel but it is reading the
track length as hours and minutes when it is in format 04:32. How do I get it
to read this as minutes and seconds so that I can organise lists and do sums
on total running time.

Thanks
--
Ravi B