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
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]
