Importing time into correct format

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I'm importing data from a phone system which has data in
mm:ss format into Excel. When doing this Excel
automatically (no options during import) changes time to
hh:mm:ss format. If I try to change after import, excel
drops the hour rather than moving things over. For
instance 36:49 (mm:ss), imports as 36:49:00 and when
changed goes to 49:00. HELP! How can I import in
correct format?
 
Karen,

Import the time as a string, then use a column of formulas to convert your
values:
=TIMEVALUE("00:"&A1)
will convert the string in cell A1 to the proper time, if formatted as time.

After conversion, copy and paste values, then delete your column of strings.

HTH,
Bernie
MS Excel MVP
 

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

apply conditional format to time 1
Time format 2
Convert data into proper time format 1
Time Sum in Excel 1
Sum Time - strange result (site & cpearson researched) 4
problem working with time data imported from text file 1
Imported time text to seconds 7
Use SUM to add time format 5

Back
Top