Convert Text to time value

  • Thread starter Thread starter Hillheader
  • Start date Start date
H

Hillheader

Hi

I have a text value HH:MM:SS a/p.m. (eg 7:02:43 a.m. or 12:18:18 p.m.
and I need to convert this to a HH:MM:SS value in the 24 hour format t
allow easier sorting.

Can anyone help with the syntax please?

Cheer
 
With your sample time in cell A1, I got this formula to generate
something appropriate:
=TEXT(HOUR(A1),"00")&TEXT(MINUTE(A1),"00")

....where the time in A1 is an Excel-readable time format. Does that
get you close?
 
Dave

Thanks for taking the time to reply.

In searching further I actually found an even quicker way. If I simpl
replace the "a.m." with "AM" and the "p.m." with "PM" it changes th
structure of the cell so that formatting the column now does th
convertion for me.

Again thanks for the reply. Much appreciate
 

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

Convert to Military time? 2
Accumulated Time Format 2
How can I convert or format an elapsed time to show mm:ss 4
Converting hh:mm:ss to seconds only 2
hh:mm:ss keeps converting to a date 4
Time Formats 3
Formatting appearance of Time Values 3
Calculating Hours, Minutes and Seconds 6

Back
Top