time format

[Latha Mani]

Hi

I need all the time format given in column A to be in the format as in column B.Please help.


Thanks

[Olly]

Try:

Please Login or Register  to view this content.

[Latha Mani]

Try:

Please Login or Register  to view this content.

am new to macros..i just inserted this code in module..but not working..kindly help

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards, TMS

[Latha Mani]

Maybe:

Please Login or Register  to view this content.

Regards, TMS

Nope..its not working

[TMS]

Both functions work as expected with your sample data.

See the updated sample workbook with both functions.

Nope..its not working

is not a very helpful comment.

[Latha Mani]

Both functions work as expected with your sample data.

See the updated sample workbook with both functions.

is not a very helpful comment.

Thank you so much TMS..am new to this code functions..hence struggled in running it..thanks a lot both of u

[Olly]

am new to macros..i just inserted this code in module..but not working..kindly help

You can use it directly in the worksheet - so in cell B2, enter:

Please Login or Register  to view this content.

and copy down to B351.



Or you can write a little code to set the values:

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.

For future reference, please do not quote whole posts. It is unnecessary and just clutters the thread.

Regards, TMS

[Latha Mani]

Hmm..sure TMS Thank u for ur words..

[Latha Mani]

Thanks olly..