Table 6.

Instructions for creating an automatic timestamp for data entry per interval

Instruction	Description	Explanation	Alterations
1. Label the column that will count the cells that need data entered	(a) Type “Count Intervals” into cell K1.
2. Enter the formula that will count how many cells need to have data entered.	(a) Select cell K2 and enter the formula [=COUNTIF(B2:E2,“”)], then press ENTER (RETURN) on the keyboard.	This formula will count the number of cells that are blank indicated by “” per cell. For this example, a 4 will be produced. As data are entered in cells, the 4 will automatically reduce.	If more target behaviors were added to the data sheet, “B2:E2” in the formula should be extended to include each cell a target behavior is tracked in.
3. Copy the formula for each interval.	(a) Drag down to cell K7.		Any added rows should be included.
4. Format the cells.	(a) While K2:K7 is still highlighted, on the HOME Tab, in the NUMBER section, open NUMBER FORMAT dropdown menu. i. Select GENERAL on the dropdown menu. (“4” should appear in each cell).	All the cells must be formatted to register the input or it will not calculate correctly.
5. Label the column that timestamps the interval.	(a) Type “Interval Timestamp” into cell L1.
6. Enter timestamp formula.	(a) Select cell L2 and enter the formula [=IF((K2 = 0),IF(L2 = “”,NOW(),L2),“”)], then press ENTER (RETURN) on the keyboard.	This produces a single timestamp output for the entire interval so that each individual target behavior timestamp does not need to be calculated and graphed.
7. Copy the formula for each interval.	(a) Drag down to cell L7.		Any added rows or columns should be included.
8. Format the cells.	(a) While L2:L7 is still highlighted, on the HOME Tab, in the NUMBER section, open NUMBER FORMAT dropdown menu. (b) Select TIME on the dropdown menu.	All the cells must be formatted to register the input for the timestamp as time or it will not calculate correctly.