|If you are going to be using Date & Time in Excel, it would be wise to learn how|
Excel actually calculates them.
Excel stores dates and times as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day in the form: ddddd.tttttt .
This is called a serial date, or serial date-time.
So the current Date & Time is: 6/14/2012 16:34
or as Excel sees it: 41074.69028
See here for more complete info: