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