{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
Excel function application function of the date and time detailed tutorial (with examples)
Finishing by: Date:2009-04-11 12:45:05 Popularity: Tags:tutorial
Tutorial in the data processing form, the date and time function is very important to deal with the basis. Excel in this regard and also provide a considerable wealth of functions for your use.

(a) remove the current system time / date information for

out the current system time / date information are mainly a function of NOW, TODAY. grammatical form

are function names ().

(b) obtain the date / time part of field values if separate

years, months, days or hours of data, you can use the HOUR, DAY, MONTH , YEAR function directly from the date / time to retrieve the data needed. Specific examples see Figure 5.

For example, the need to return 2001-5-30 12:30 PM the year, month, days and hours, can be used to achieve the corresponding functions.

YEAR (E5) = 2001

MONTH (E5) = 5

DAY (E5) = 30

HOUR (E5) = 12


Figure 5

more useful addition to the Date / Time function, you can access the Schedule. We will be following a specific example to illustrate the text of Excel functions and uses the date function.
there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1