Value in a cell between two times

[ca_author]

I'm not an advanced excel user, and there is probably a very simple formula for this, but I am wondering if there's a way to record the value of a cell at a certain time.

I'm a writer and I track my word count progress (cell C11) for each hour of the day. Right now, I'm putting it in manually at the bottom of every hour, but if there's a way for excel to do it automatically at 5:59:59 AM, 6:59:59 AM etc, that would be great. I don't need to keep the data after the current day (I'd actually like it to only record the current day).

Any help you could give me would be much appreciated.

Thanks!

 

[jim may]

Check out the

Application.OnTime Method

<tbody>
</tbody>

Schedules a procedure to be run at a specified time in the future (either at a specific time of day or after a specific amount of time has passed).

In the VBE Help Screen.