Chris Hand from Zeke's Gallery wrote:
Howdy!
I am using OpenOffice 2.0.2.2ubuntu12.1
I have one cell in a spreadsheet that contains the function Now(). I
have another cell that contains the exact time that my sweetie is
coming home.
I have a third cell where I subtract Now() from the time she is coming
home, so I know exactly how many days, hours, minutes and seconds it
is until I see her.
When the cell is formatted as a Date and DD:HH:MM:SS it is shows one
day less than is actually the case.
When the cell is formatted at a Date and [HH]:MM:SS it shows the
correct amount of time, but I then have to calculate how many days
that is myself.
Thought someone would like to know, especially since my sweetie is
coming home in less than 48 hours. Or 1 day, 0 hours.
I'm not subscribed to any mailing list so if anyone would like a copy
of the spreadsheet or a screen shot, or has any follow up with me,
please email me directly. Thanks
DD always displays the day of the month of the value, which is assumed
to be a date. Dates are represented internally by a floating point
number, where the integer part is the number of days from some epoch,
which defaults to Dec 30, 1899 in OOo 2.0 (but can be changed in the
Tools -> Options -> Spreadsheet -> Calculate). So when you calculate the
difference between two date/times and format it as DD, then Calc takes
that value to be a date. E.g.
(Jul 30 2006) - (Aug 1 2006) = 2
Formatted as DD this displays (Dec 30 1899) + 2 = Jan 1 1900 = 1
You need to duplicate the date/time difference value in a separate cell
and format it as a number, and format the original difference as HH:MM
isnce this will still display the correct time difference (represented
by the fractional part of the value, which is the fraction of 24 hours).
Ross
Chris Hand
Zeke's Gallery
http://zekesgallery.blogspot.com
~> Click on an ad & Zeke's Gallery gets 35ยข <~
Cool, eh?!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
