Home |
Search |
Today's Posts |
#1
|
|||
|
|||
funcation
i would like about this funcation
now all thing |
#2
|
|||
|
|||
From HELP:
NOW Returns the serial number of the current date and time. Syntax NOW( ) Remarks Microsoft Excel stores dates as sequential serial numbers so that it can perform calculations on them. Excel stores January 1, 1900, as serial number 1 if your workbook uses the 1900 date system. If your workbook uses the 1904 date system, Excel stores January 1, 1904, as serial number 0 (January 2, 1904, is serial number 1). For example, in the 1900 date system, Excel stores January 1, 1998, as serial number 35796 because it is 35,795 days after January 1, 1900. Learn more about how Microsoft Excel stores dates and times. Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different default date systems. Excel for Windows uses the 1900 date system, in which serial numbers correspond to the dates January 1, 1900, through December 31, 9999. Excel for the Macintosh uses the 1904 date system, in which serial numbers correspond to the dates January 1, 1904, through December 31, 9999. Numbers to the right of the decimal point in the serial number represent the time; numbers to the left represent the date. For example, in the 1900 date system, the serial number 367.5 represents the date-time combination 12:00 P.M., January 1, 1901. You can change the date system by selecting or clearing the 1904 date system check box on the Calculation tab of the Options command (Tools menu). The date system is changed automatically when you open a document from another platform. For example, if you are working in Excel for Windows and you open a document created in Excel for the Macintosh, the 1904 date system check box is selected automatically. The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. Examples If you are using the 1900 date system and your computer's built-in clock is set to 12:30:00 P.M., 1-Jan-1987, then: NOW() equals 31778.52083 Ten minutes later: NOW() equals 31778.52778 hth Vaya con Dios, Chuck, CABGx3 "wassim" wrote in message ... i would like about this funcation now all thing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get excel to show mm/dd in Funcation bar | Excel Discussion (Misc queries) | |||
Funcation to average the Time spent | Excel Worksheet Functions |