Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Display the time, combined with text

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