Gold Star for you today, Doug! I went ahead and took it a step further,
because I *know* it will be asked by the users anyway... (corrected)
IF(HOUR(Planned Completion Date)<13,CONCAT(HOUR(Planned Completion
Date),":",RIGHT(100+MINUTE(Planned Completion Date),2),"
","AM"),CONCAT((HOUR(Planned Completion
Date)-12),":",RIGHT(100+MINUTE(Planned Completion Date),2)," ","PM"))
Thanks!! William English