Display the time, combined with text : NOW « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. NOW
Input the formula: =TEXT(NOW(),"h:mm AM/PM")
Input the formula:
15.10.NOW
15.10.1.=NOW() returns the current date and time
15.10.2.Display the current time as a time serial numberDisplay the current time as a time serial number
15.10.3.Display the time, combined with textDisplay the time, combined with text