Determining AM or PM in text string
 

I created the following formula:
="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @ "&HOUR(NOW())&":"&MINUTE(NOW())
and I would like to add "AM" or "PM" to it.
Can someone help me modify my formula to include it?
Thanks for the help.

Determining AM or PM in text string
 

Hi Bob,

="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @
"&HOUR(NOW())&":"&MINUTE(NOW())&" "&IF(HOUR(NOW())12,"PM","AM")

HTH
Carim

Determining AM or PM in text string
 

Hi Bob,

="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @ "&HOUR(NOW())&":"&MINUTE(NOW())&IF
(HOUR(NOW())<=11," am"," pm")

HTH

Simon

(This will work when the clock is set to 24h, but I have not testest it on
the 12h setting)

Bob wrote:
I created the following formula:
="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @ "&HOUR(NOW())&":"&MINUTE(NOW())
and I would like to add "AM" or "PM" to it.
Can someone help me modify my formula to include it?
Thanks for the help.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1

Determining AM or PM in text string
 

="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @
"&MOD(HOUR(NOW()),12)&":"&MINUTE(NOW())&IF(HOUR(NO W())12," PM"," AM")
--
David Biddulph

"Bob" wrote in message
...
I created the following formula:
="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @ "&HOUR(NOW())&":"&MINUTE(NOW())
and I would like to add "AM" or "PM" to it.
Can someone help me modify my formula to include it?
Thanks for the help.

Determining AM or PM in text string
 

Carim - Thanks!
Bob

"Carim" wrote:

Hi Bob,

="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @
"&HOUR(NOW())&":"&MINUTE(NOW())&" "&IF(HOUR(NOW())12,"PM","AM")

HTH
Carim

Determining AM or PM in text string
 

Thanks!
Bob


"smw226 via OfficeKB.com" wrote:

Hi Bob,

="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @ "&HOUR(NOW())&":"&MINUTE(NOW())&IF
(HOUR(NOW())<=11," am"," pm")

HTH

Simon

(This will work when the clock is set to 24h, but I have not testest it on
the 12h setting)

Bob wrote:
I created the following formula:
="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @ "&HOUR(NOW())&":"&MINUTE(NOW())
and I would like to add "AM" or "PM" to it.
Can someone help me modify my formula to include it?
Thanks for the help.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1

Determining AM or PM in text string
 

Alternatively, try:

=TEXT(NOW(),"A\s of mm/dd \@ h:mm AM/PM")

Determining AM or PM in text string
 

Lori,
Thanks!!! I like your solution the best because the formula is short (and
efficient), and it doesn't display the time in military format.
Thanks again,
Bob


"Lori" wrote:

Alternatively, try:

=TEXT(NOW(),"A\s of mm/dd \@ h:mm AM/PM")

Determining AM or PM in text string
 

Happy to assist, it's the same as entering =NOW() and formatting the
number as in the formula.

Bob wrote:

Lori,
Thanks!!! I like your solution the best because the formula is short (and
efficient), and it doesn't display the time in military format.
Thanks again,
Bob


"Lori" wrote:

Alternatively, try:

=TEXT(NOW(),"A\s of mm/dd \@ h:mm AM/PM")