Convert Text Time to Time

  • Thread starter Thread starter mdalby
  • Start date Start date
M

mdalby

I have text in the following format:

800
830
900
930

How can I convert these text to 8:00 AM, 8:30 AM etc...

Thanks,

M
 
One way
Use this formula:

=IF(A1/100<12,LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2)&"AM",LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2)&"PM")

There may be an easier way, perhaps using special formats, but thi
should do the job for you
 

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

converting numbers to time 3
convert number to date format 4
how can I get excel to fill using a start and finish time 1
How to convert OST to PDF? Simple Methods 4
How many are at work every hour in a 24-hour day? 2
How Can I Convert MBOX to HTML File? 0
Sort by Large, Offset from Match, Duplicate values problem 2
How to convert a .msg File? 2

Back
Top