Short Time?

C

Cameo

What is the correct code to have the Now() be 8:22 pm?

Format(Now(),"Short Time") gives me military time.

Please help!

Thanks!

Cameo
 
D

david epsom dot com dot au

'Short Time' is your system setting
(Start | Settings | Control Panel | Regional Settings)

To override your system setting,

Format(Now(),"h:mm am/pm")
or
Format(Now(),"h:mm AMPM")

(david)
 
J

John Vinson

'Short Time' is your system setting
(Start | Settings | Control Panel | Regional Settings)

To override your system setting,

Format(Now(),"h:mm am/pm")
or
Format(Now(),"h:mm AMPM")
Click to expand...

that's actually h:nn - m is months, not minutes! Otherwise exactly
right.
 
D

david epsom dot com dot au

that's actually h:nn - m is months, not minutes!

trips me every time....

(david)
 
Top