Enter a Time on a 12-hour clock : Value Input « Editing « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Editing
  3. Value Input
Type the hour based on a 12-hour clock, followed by a colon (:), then the minute, then a space, and ending with an "a" or a "p" to denote A.M. or P.M. Press Enter.
Type the hour based on a 12-hour clock, followed by a colon (:), then the minute, then a space, and ending with an 'a' or a 'p' to denote A.M. or P.M. Press Enter.
Check the Result
Result








2.16.Value Input
2.16.1.Enter a Text LabelEnter a Text Label
2.16.2.Enter a Number as a LabelEnter a Number as a Label
2.16.3.Entering Values on a WorksheetEntering Values on a Worksheet
2.16.4.Enter a DateEnter a Date
2.16.5.Enter a Time on a 12-hour clockEnter a Time on a 12-hour clock