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
 
Back
Top