Convert hh:mm to hh:mm:ss

[Pergo]

I'm trying to convert time from hh:mm to hh:mm:ss

Example:

My Data is: 9:38 AM
I want it: 09:38:00

It can either replace the current values or place in a new column.

Would I be able to do this in a macro?

[dwint]

perhaps like this

Please Login or Register  to view this content.

[Winon]

Hi Pergo,

Why would you want to use VBA, if you could just enter this into a cell =NOW() and Format Cell to hh:mm:ss.

[Pergo]

Now would only work with the current/date time, right?

Dwint, how would I be able to use that for my range. So lets say the range is C293:C600

[Winon]

No not really.

You could format any Cell or range of Cells where you want the time to display as 09:15:38 to the Format
hh:mm:ss, and it will work.

[dwint]

this code will convert all data in range c293 : c600 from hh:mm AM/PM into h:mm:ss

Please Login or Register  to view this content.

[Pergo]

This works perfectly, Thanks!!!