Extract hour from TIME in NON-Military time

Hi,

I am trying to put the time in the file name in this manner. Lets say its 9pm.........

Then the filename would be something like this

ABCDEF_9_00_PM

I know i can get the time from the "Time" command in VBA.

From this i can extract the hour, min and AM/PM.

The problem is when i extract the hour it is in military time:

Please Login or Register  to view this content.

The above could could produce hours_2Digit = 21

I want it to be hours_2Digit = 9

Any ideas?

something like

Please Login or Register  to view this content.

buran, will yours work if its say 9pm?

Or

Please Login or Register  to view this content.