SOLVED

Download excel file with time

%3CLINGO-SUB%20id%3D%22lingo-sub-2401955%22%20slang%3D%22en-US%22%3EDownload%20excel%20file%20with%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401955%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20file%2C%20with%20time%20columns%20but%20doesn't%20recognize%20as%20%22time%22%2C%20there%20is%20any%20option%20that%20I%20can%20convert%20without%20having%20to%20write%20one%20by%20one%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2401955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401978%22%20slang%3D%22en-US%22%3ERe%3A%20Download%20excel%20file%20with%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401978%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1067789%22%20target%3D%22_blank%22%3E%40Dirkalbert%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20some%20reason%2C%20all%20five%20columns%20contain%20text%20values%2C%20even%20though%20they%20are%20formatted%20as%20date%20or%20time.%3C%2FP%3E%0A%3CP%3EDo%20the%20following%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20column%20A.%3C%2FLI%3E%0A%3CLI%3EOn%20the%20Data%20tab%20of%20the%20ribbon%2C%20click%20Text%20to%20Columns.%3C%2FLI%3E%0A%3CLI%3EClick%20Next%20%26gt%3B%20twice%2C%20so%20that%20you%20are%20on%20Step%203.%3C%2FLI%3E%0A%3CLI%3ESelect%20Date%2C%20and%20select%20DMY%20from%20the%20dropdown.%3C%2FLI%3E%0A%3CLI%3EClick%20Finish.%3C%2FLI%3E%0A%3CLI%3ESelect%20column%20C%20and%20do%20the%20same.%3C%2FLI%3E%0A%3CLI%3ESelect%20an%20empty%20cell%20and%20copy%20it.%3C%2FLI%3E%0A%3CLI%3ESelect%20columns%20B%2C%20D%20and%20E.%3C%2FLI%3E%0A%3CLI%3ERight-click%20anywhere%20in%20the%20selection.%3C%2FLI%3E%0A%3CLI%3ESelect%20Paste%20Special...%20from%20the%20context%20menu.%3C%2FLI%3E%0A%3CLI%3ESelect%20Add.%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3CLI%3ESet%20the%20number%20format%20to%20a%20time%20format.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EExecuting%20this%20took%20less%20time%20than%20writing%20it%20down...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello there!

 

I have an excel file, with time columns but doesn't recognize as "time", there is any option that I can convert without having to write one by one?

 

2 Replies
best response confirmed by Dirkalbert (New Contributor)
Solution

@Dirkalbert 

For some reason, all five columns contain text values, even though they are formatted as date or time.

Do the following:

  • Select column A.
  • On the Data tab of the ribbon, click Text to Columns.
  • Click Next > twice, so that you are on Step 3.
  • Select Date, and select DMY from the dropdown.
  • Click Finish.
  • Select column C and do the same.
  • Select an empty cell and copy it.
  • Select columns B, D and E.
  • Right-click anywhere in the selection.
  • Select Paste Special... from the context menu.
  • Select Add.
  • Click OK.
  • Set the number format to a time format.

Executing this took less time than writing it down...

Tks for the Help!