 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006Formula for computing day of the week and time
I have a cell containing information in the following format: Mon 6/12/2006 2:56 PM I would like to break this into 3 individual cells for day (spelled out IE Monday) date and time. I would also like a formula to convert 2:56 PM into something more generic like "Afternoon" or "Early AM" Any help would be appreciated thanx. =TEXT(A1,"dddd") =INT(A1) formatted as date =SUBSTITUTE(SUBSTITUTE(TEXT(MOD(A1,1),"h:mm AM/PM"),"AM","Morning"),"PM","Afternoon") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > I have a cell containing information in the following format: > [quoted text clipped - 7 lines] > > Any help would be appreciated thanx. I'm afraid these formulas did not work. The first one simply mirrored the A1 Cell, the second and third ones said there was an error with the formula. Any idea's as to why they are not working? > =TEXT(A1,"dddd") > [quoted text clipped - 22 lines] > > > > Any help would be appreciated thanx. Sorry the third one gave me a #VALUE! error but did let me use it in the cell. Cryptographic_...@yahoo.com wrote: > I'm afraid these formulas did not work. The first one simply mirrored > the A1 Cell, the second and third ones said there was an error with the [quoted text clipped - 26 lines] > > > > > > Any help would be appreciated thanx. The only thing I can think is that the cell is text, not a date/time format. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > Sorry the third one gave me a #VALUE! error but did let me use it in > the cell. [quoted text clipped - 30 lines] > > > > > > > > Any help would be appreciated thanx. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.