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