|Are the Date & Times in the same cell, or in separate cells?|
If there in the same cell try this Custom Format:
dddd mmmm d h:mm AM/PM
If there in separate cells, just break it apart:
Date = dddd mmmm d
Time= h:mm AM/PM
Still gives you the zeros at 5:00 PM, but it's as close as I can get right now.
I'll keep working on it.