| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
AM /PM formula help please
On Sun, 2 Sep 2007 22:55:38 -0400, "Rick Rothstein \(MVP - VB\)"
wrote: =RIGHT(TEXT(A1,"h:mm am/pm"),2) Unless I am missing something, I believe you can shorten that to this... =TEXT(A1,"am/pm") Rick Good. I never tried that. --ron |
Threaded Mode
