Formula for computing day of the week and time

C

Cryptographic_ICE

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.
 
B

Bob Phillips

=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)
 
C

Cryptographic_ICE

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?
 
C

Cryptographic_ICE

Sorry the third one gave me a #VALUE! error but did let me use it in
the cell.
 
B

Bob Phillips

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)
 
Top