| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Determining AM or PM in text string
Alternatively, try:
=TEXT(NOW(),"A\s of mm/dd \@ h:mm AM/PM") |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I grab the date from a text string? | Excel Worksheet Functions | |||
| Find & Replace text format | Excel Discussion (Misc queries) | |||
| Text string and sum | Excel Worksheet Functions | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
Linear Mode
