Short Time?

  • Thread starter Thread starter Cameo
  • Start date Start date
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
 
'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)
 
'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.
 
that's actually h:nn - m is months, not minutes!

trips me every time....

(david)
 
Back
Top