Microsoft Office Tutorials and References
In Depth Information
Examples of Date and Time Functions
As shown in Figure 11.36 , the time formatting codes include various combin-
ations of h, hh, s, ss, :mm, and mm:, all of which can be modified with square
brackets.
Figure 11.36.
Figure 11.36. Custom time format codes.
Custom time format codes.
To display date and time, you enter the custom date format code, a space, and
then the time format code.
Examples of Date and Time Functions
In all the examples in the following sections, you should use care to ensure
that the resulting cell is formatted using the proper format, as discussed in
the preceding section.
Search JabSto ::




Custom Search