On Saturday 29 July 2006 04:23 pm, 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
>
> Chris Hand
> Zeke's Gallery
> http://zekesgallery.blogspot.com
> ~> Click on an ad & Zeke's Gallery gets 35ยข <~
> Cool, eh?!
You have received some suggestions already on how to do this.
Here is another one.
Assumptions:
(1) Cell A1 contains the date and time your sweetie is due. I
formatted mine with NN, MMM D, YY HH:MM:SS.
(2) Cell A2 contains the NOW() function. I formatted A1 and A2 the
same.
Calculations:
(1) Number of days. Format A3 as -1234 (O decimal places and 1 leading
zero). Use the Days function. =DAYS(A1;A2).
(2) Number of hours, minutes, and seconds. Format A4 as 13:37:46
(HH:MM:SS). Subtract: =A1-A2.
A3 should then show the correct number of days, and A4 will show the
correct number of hours, minutes, and seconds.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
