Time conversion

[JoboM]

Hi there gurus!

I'm trying to convert a general entry into a cell into a time format. The general entries are all entered as 06:00am for example. I've tried changing the formatting of the cells but as the data is pulled from a website it continually enters refreshed data as a general format.

Is there a code that will change a general entry in the cells in the range (O6:O92) from a ##:##am or ##:##pm to a time format??

Thank you kind people!

Have an excellent day!

 

[JoeMo]

Hi there gurus!

I'm trying to convert a general entry into a cell into a time format. The general entries are all entered as 06:00am for example. I've tried changing the formatting of the cells but as the data is pulled from a website it continually enters refreshed data as a general format.

Is there a code that will change a general entry in the cells in the range (O6:O92) from a ##:##am or ##:##pm to a time format??

Thank you kind people!

Have an excellent day!

Have you tried replacing "am and "pm" by " am" and " pm" (i.e put a space before am and pm)?

 

[mfexcel]

If you can use a helper column... try
in P6
=(LEFT(O6,5)&" " &RIGHT(O6,2))+0
Change the cell format to "hh:mm am/pm"
Copy down

Hi there gurus!

Is there a code that will change a general entry in the cells in the range (O6:O92) from a ##:##am or ##:##pm to a time format??

Have an excellent day!

 

[JoboM]

The data auto fills, so I think I'd need a code to make adjustments as it fills?

 

[JoboM]

If you can use a helper column... try
in P6
=(LEFT(O6,5)&" " &RIGHT(O6,2))+0
Change the cell format to "hh:mm am/pm"
Copy down

Thanks! This worked perfectly

 

[mfexcel]

You are welcome.

Thanks! This worked perfectly