date/time value

A date/time value is a value or a reference to a cell containing a date/time value in any of the formats supported by Keynote, Pages or Numbers. You can choose to display only a date or time in a cell, but all date/time values contain both a date and a time.

Date/time values can use the 24-hour format or include am, pm, AM or PM. Time values of “11:00”, “11:00am”, “11:00 am”, “11:00AM” and “11:00 AM” are all equivalent. Time values of “23:00”, “11:00pm”, “11:00 pm”, “11:00PM” and “11:00 PM” are also all equivalent. The use of full stops (such as “a.m.”) is not supported.