Date Time Functions MSOfficeExcel 2007 Tutorial

Input the formula: =TEXT(NOW(),"h:mm AM/PM")