That doesn't work either. Maybe I'm putting it in the wrong place?
Does it need to go at the end, and if so, how do I conncect it to the
other formula since its all in the same cell? Also, I don't understand
what you mean by that I need to append the AM or PM??



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!