<HTML
><HEAD
><TITLE
>Date and Time formatting</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="HOME"
TITLE="Gnumeric's user manual"
HREF="gnumeric.html"><LINK
REL="UP"
TITLE="Cell Formatting"
HREF="formatting.html"><LINK
REL="PREVIOUS"
TITLE="Number formatting overview"
HREF="x669.html"><LINK
REL="NEXT"
TITLE="Worksheet overview."
HREF="worksheet.html"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Gnumeric's user manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="x669.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 3. Cell Formatting</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="worksheet.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="AEN683"
>Date and Time formatting</A
></H1
><P
>Gnumeric supports a wide variety of date and time formatting.</P
><P
>These formats can be used to convert an existing time serial number
   into a new more readable format, or dates can be entered in these formats
   and Gnumeric will automatically convert them to a serial number with the
   proper cell format. See <A
HREF="editing.html#ENTERING-DATES-AND-NUMBERS"
>the section called <I
>Dates and Numbers</I
> in Chapter 1</A
> for more
   information.</P
><P
>In <A
HREF="x683.html#NUMBER-FORMAT-DATE-TIME-EXAMPLES"
>Example 3-3</A
>  'd' is a day,
  'm' is a month, 'y' is a year, 'h' is an hour, and 's' is a second.</P
><DIV
CLASS="EXAMPLE"
><A
NAME="NUMBER-FORMAT-DATE-TIME-EXAMPLES"
></A
><P
><B
>Example 3-3. Date and Time Formatting.</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="PROGRAMLISTING"
>&#13;    Date
        Format                     Sample
   Serial number		36068.7	
   m/d/yyyy	        	10/1/1998	
   d-mmm-yy		        1-Oct-98	
   d-mmm-yyyy		        1-Oct-1998	
   d-mmm		        1-Oct	
   d-mm		                1-10	
   mmm/d		        Oct/1	
   mm/d		                10/1	
   mm/dd/yy		        10/01/98	
   mm/dd/yyyy		        10/01/1998	
   mmm/dd/yy		        Oct/01/98	
   mmm/dd/yyyy		        Oct/01/1998	
   mmm/ddd/yy		        Oct/Thu/98	
   mmm/ddd/yyyy		        10/01/1998	
   mm/ddd/yy		        10/Thu/98	
   mm/ddd/yyyy		        10/Thu/1998	
   mmm-yy		        Oct-98	
   mmm-yyyy		        Oct-1998	
   m/d/yy h:mm		        10/1/98 16:48	
   m/d/yyyy h:mm                10/1/1998 16:48	


Time

      Format                     Sample
  Serial number		       36068.7	
  h:mm:ss AM/PM		       4:51 PM	
  h:mm:ss AM/PM		       4:51:18 PM	
  h:mm		               16:51	
  h:mm:ss		       16:51:18	
  m/d/yy h:mm		       10/1/98 16:51	
  mm:ss		               10:18	
  mm:ss.0		       10:1836068.7	
  [h]:mm:ss		       :10:18	
&#13;</PRE
></TD
></TR
></TABLE
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="x669.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="gnumeric.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="worksheet.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Number formatting overview</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="formatting.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Worksheet overview.</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>