Hi I’m trying to automate a calculation that up until now I have been doing manually. The problem is I forget to do it each day as I wanted. Lets say I have the NOW() function in cell P374 to display the current date and time. Now what I want to do is on the following day at 2:00 PM I want the contents of cell I375 to be copied to cell O375. I want this to happen at 2:00 PM each day, but at no other time. Is it possible to do this calculation.
I have been playing with it trying to figure it out on my own, but have run ino a snag. I can set the End Time I want using TIMEVALUE(), and have even successful in showing the difference in hours and minutes between the current time and the projected time {2:00 PM} but the numerical values between NOW() {Numerical format example (45218.7340692361)} and TIMEVALUE {Numerical format example (0.583333333333333)} do not match and I’ve been unsuccessful in getting them to do so so I can use a Conditional statement to do the switch of contents in I375 to O375. Even trying to use the difference calculation in Hours and minutes returns an error. Any help would be appreciated.
Welcome!
Okay, let’s say that we found a way to fix the current value of I375 in O375. Even if this did not happen exactly at 14:00, but for example at 14:00:15 or even at 14:05 - the computer was not turned on, or the document was not open, or a thousand other reasons prevented it from being done at the exact time, but it happened. … Do you need to remember somewhere separately that the value in O375 was like this yesterday, and like this the day before yesterday? I mean do you need the modification history of this cell?
And by the way, are we talking about only one value or will there be many such time-varying cells?
a simple Option would be to assign →Tools→Customize→Events → ( look out for sth. sensefull ) to a Macro-routine that calculates the Number of Days since »initial Date 14PM« and fill that Number of Cells in a Row with »Content of I375«
As long as it updates daily after 14:00 when the computer is on would be acceptable after the previous date. A checkdate function in other words. I considered daily, weekly, monthly, and yearly, but it seemed too much. Daily would be fine, but weekly also would be sufficient as the program the spreadsheet monitors through my inputs updates every Thursday at exactly 14:00. If doing it daily it only made sense to do it at the same time as on Thursday. As for the reason I want to know the changes from day to day I’m keeping track of a type of financial changes within a seperate program. Knowing this will help me track inventory in the program on a regular basis.
I will have to study on how that works. I have some macro writing experience, but that is for a seperate program, and do not know what format changes would be likely between the program and Libraoffice