Changing Text to Time in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large database that is sent to me for anaysis on a regular basis.
My problem is with times. They are sent to me in the for 0122 as text. I
need help converting them to a time that excel can deal with (without
manually fixing them, as there's about 100,000 pieces of data that need to be
updated).

Thanks your your help.
 
add a helper column

=TIME(LEFT(A2,2),Right(A2,2),0)

and copy down
 
You must log in or register to reply here.

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

How can we convert OST to PDF file format? 1
Which is the best RPMSG to PDF converter in 2026? 1
How to Convert EML to PST? 2
Migrating from Amazon WorkMail to Microsoft 365 2
IF Logic Function with negative time or early time 1
Custom Formatting (# x 1000) 2
Importing Long Numbers as Text cells 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top