Time format in macro

[Maha]

Hi...pls help me out to fix the timeformat issue in macro. I need to put time as
"10.12 am". So, how to include am/pm in our time diplay

 

[VoG]

Try

Range("A1").Value = Format(Time, "hh:mm AM/PM")

 

[Maha]

Thanks VoG..

 

[Maha]

I need to include the horizontal alignment also in that cell...how to incorporate alignment in time format macro?

 

[VoG]

The easiest way to get the code for that is to record a macro whilst setting the format manually.