On 5/10/2010 4:41 PM, Daniel Lewis wrote:
James Knott wrote:
JOE Conner wrote:
Not at all, because the same number is also be used for date AND time.
Both date and time are normally integers. Like with money, you
wouldn't normally use floating point because you can't be guaranteed
a correct result. With FP, you can get round off errors.
40308.8173611111 is May 10,2010 at 7:37 PM.
This is sufficient to describe todays date and time.
Dan
If this explanation is not working for you yet try this:
Try this:
1. Open a new Calc spreadsheet.
2.
In cell A1 enter the number 40308.77274692134
3.
Select cell A1 again by clicking on it once.
4.
Format the cell as DATE using the second choice down from the top.
It will display Monday, May 10, 2010. (Dates are in my instance
the USA locality).
5.
Without changing anything else, reformat the cell as time. It will
now display 06:32:45PM.
6.
Again, without changing anything else, reformat the cell as date.
This time choose the format 12/32/1999 13:37:46. This time it will
display 05/10/2010 18:32:45.
All this from the same cell containing a only floating point number
40308.77274692134. The format is purely arbitrary (even eye candy), the
contents of the cell are not. Thus, sorting on a date formatted column
should work correctly.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
