|
| |
Dates and Times
| You might think you are looking at a date or time, but
you're not. That's just the way it's being displayed. Underneath is a number
such as 37962.44306 which represents 07-Dec-2003 10:38:01 The number is a
counter from 1st January 1900. |
| |
| Add 15 minutes to a time value: = value + ((15/60)/24) |
| |
| Formula to subtract seven years from the date in cell A1:
A1-(DATE(7,1,0)) |
| |
| |
| |
| |
| |
| |
| |
| Published |
07-Dec 2003 |
| Last updated: |
05-Jun-2005 19:19 |
|
