Capture Value from a Cell only once at a specific hour.

As this is an entire project, you might wish to consider the Commercial Services section.

While you are considering whether to move to commercial services, have you seen Chandoo's time stamp circular reference formula? https://chandoo.org/wp/timestamps-excel-formula-help/ It seems like this should be very similar to those time stamp formulas -- (pseudocode) =IF(NOW() is within threshold of today at 10:00 AM,C1,D1). Like your other MIN()/MAX() tracking sheets, this requires iteration be enabled so Excel can resolve the circular reference. If D1 is blank when the formula is entered, D1 should be 0 after entry if the condition is not met. If needed, you may want to consider a reset condition, if you have trouble with the cell showing non-zero values before 10 AM. Recognize that the NOW() function returns both date+time information, so your final formula will need to account for that as well.

Would something like that work for you?

Your post does not comply with Rule 3 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Please make sure to include the full link, so that other members will be permitted to continue helping you

@alansidman -- Is it crossposted somewhere other than the chandoo forum that he/she already included (post #3)?

Originally Posted by MrShorty

@alansidman -- Is it crossposted somewhere other than the chandoo forum that he/she already included (post #3)?

Yes. Also MrExcel.

This thread has never been unavailable to you - I don't know why you were not able to post to it.

yes, dont know why I was not able to find the thread after submitting the same.

thanks,

I am a little surprised that worked exactly as you requested-- maybe because I misunderstood the logic. Here's what I see it doing:

At 9:45 -- Now()-TODAY() is 9:45, which is less than 10:00, so conditional test is false and D1 returns the value in C1. I thought the intention was to have the cell be blank or 0 before 10:00, did I misunderstand?
At 10:00 -- Now()-Today() is 10:00, which is equal to (not greater than) 10:00 (barring floating point error), so conditional test is still false, and D1 returns C1 again. If C1 changed in those 15 minutes, then D1 changes.
At 10:15 -- Now()-Today() is 10:15, which is greater than 10:00, so conditional test is true, and D1 returns the current value in D1 (which is whatever it was at 10:00 AM).

So, with this logic, D1 will track C1 until 10:00, then stay fixed the rest of the day (until midnight). At midnight, when the day changes, then D1 will recommence tracking C1 until 10:00 AM. So it is similar logic, but not exactly what you talked about in the OP. If this is adequate for you, then that is fine. I just know that circular logic like this requires more careful consideration than the usual straight through linear logic that we usually employ in spreadsheets. Make sure you think this through completely so it will really do exactly what you need.