getting excel to recognise copied data as mm:ss not hh:mm

  • Thread starter Thread starter Ravi B
  • Start date Start date
R

Ravi B

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
 
You need to divide everything by 60. If you don't need the data to be
constantly uploaded, type 60 in a cell, copy it, then select all your track
data, right click. Select the "divide" option.

Now, to make it look nice, format cells, choose custom, and type
mm:ss

Excel now knows you're dealing with minutes & seconds, and will display it
the same way you're used to.

Alternative if you plan on updating list frequently is to just divinde you
math functions by 60.
 
Hi,

You won't find a Divide option on the shortcut menu, instead choose Paste
Special, and double-click the word Divide.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using time data copied and pasted into excel from external source 4
How enter time DURATIONS mm:ss (not clock times), then sum? 1
format numbers as mm:ss 3
Time Sum in Excel 1
Converting :mm:ss to ss 8
hh:mm to mm:ss 4
How to get timein hh:mm format 3
Converting a number to hours and minutes 4

Back
Top