Determining AM or PM in text string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 26 Oct 2006 12:42 GMT

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.

Reply to this Message

Carim - 26 Oct 2006 12:55 GMT

Hi Bob,

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

HTH
Carim

Reply to this Message

Bob - 26 Oct 2006 13:10 GMT

Carim - Thanks!
Bob

> Hi Bob,
>
[quoted text clipped - 3 lines]
> HTH
> Carim

Reply to this Message

smw226 - 26 Oct 2006 12:56 GMT

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)

>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.

Signature

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

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

Reply to this Message

Bob - 26 Oct 2006 13:10 GMT

Thanks!
Bob

> Hi Bob,
>
[quoted text clipped - 13 lines]
> >Can someone help me modify my formula to include it?
> >Thanks for the help.

Reply to this Message

David Biddulph - 26 Oct 2006 13:02 GMT

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

Signature

David Biddulph

>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.

Reply to this Message

Lori - 26 Oct 2006 13:29 GMT

Alternatively, try:

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

Reply to this Message

Bob - 27 Oct 2006 04:40 GMT

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

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

Reply to this Message

Lori - 27 Oct 2006 12:55 GMT

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

> Lori,
> Thanks!!! I like your solution the best because the formula is short (and
[quoted text clipped - 5 lines]
> >
> > =TEXT(NOW(),"A\s of mm/dd \@ h:mm AM/PM")

Reply to this Message