Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking time values
I am conducting a research project in Excel which requires me to record data
at specific increments of time (say every 30 minutes). Does anyone know if there is a way to link a cell (A) to another cell (B) so that A captures the data in B at a specified time of the day, say 10:30 am? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking time values
You can use a circular reference to do this. First, go to the Tools menu, choose Options, then the Calculation tab. There, check the Iterations box. Now, use the following formula in B1 =IF(MOD(MINUTE(NOW()),30)=0,A1,D1) Here, if the minute of the current time of day is 30 or 0, the formula returns the value in A1. Otherwise, the value remains the same. This way, the formula updates itself from A1 every 30 minutes. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com The San Diego Project Group, LLC (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Tue, 30 Sep 2008 11:34:00 -0700, Blaw28 wrote: I am conducting a research project in Excel which requires me to record data at specific increments of time (say every 30 minutes). Does anyone know if there is a way to link a cell (A) to another cell (B) so that A captures the data in B at a specified time of the day, say 10:30 am? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Linking cell values | Excel Discussion (Misc queries) | |||
Linking dates and values | Excel Discussion (Misc queries) | |||
linking comments to appear in cell at same time | Excel Discussion (Misc queries) | |||
linking values from one sheet to another | Excel Discussion (Misc queries) |