Auto filling

[Kidmon]

I am using excell 2007

Problem 1.
I need to create a way for cell to auto fill with 1 key stroke.
Excell already does what I want until there is a blank cell seperating cells in the column I am entering data. With one key stroke I need a cell in column H to fill in the word. In other words T="Taken" or D="Declined" or possibly N="No action needed".

Problem 2
Is there a way I can create an active timer that counts down the military time in column J. Inmates are allowed 30 min out and it would be great to know if they have 10 min, or 23 min or what ever let out. I already have reminder set up but it only tells me when "Time is up". I would like to see minute by minute changes.
Thanx for the help, This Forum's help has meant a great deal to me, Thank you again,
K

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
6	Date	Shift	Inmate Name	Red Tag	Ad Seg	Activities	Notes / Status / PC /PS / Gym / Lib	Taken / Declined	Officer no.	Time Out	Time In	Total Time Out	Time Left
7
8	5-Apr	AM	inmate name	1:1	1	Shower & Clean	no issues	Taken	1111	1636	1700	64
9	5-Apr	PM	inmate name	1:1	4	X=Meds	no issues	Declined	11112	2332	2346	14
10	5-Apr	AM	inmate name	1:1	4	Meals		Taken	10416	2228	2345	117
DDAF Form

Excel 2010

Cell Formulas
Range	Formula
A8	=NOW()
A9	=NOW()
A10	=NOW()
L8	=IF(K8-J8=0,"",K8-J8)
L9	=IF(K9-J9=0,"",K9-J9)
L10	=IF(K10-J10=0,"",K10-J10)

 

[RonB1111]

Try Data Validation for the auto fill. In another section of the worksheet enter in 3 consecutive rows of a column the words "Taken", "Declined" and "No action needed". Then select Col H, then Data-Data Validation, then select in the "Allow" box "List" and enter the range of those 3 cells in the source box. A drop down arrow will appear in each cell in Col H when you enter that cell - just click the arrow and your choice. I know it's 2 clicks but it's very quick.

For your countdown timer, assuming J8 is time formatted as "hmm" enter this formula in M8 and format as "hmm":
=J8+TIME(0,30,0)-(NOW()-INT(NOW()))
You'll have to press the function key F9 each time you want it to see the updated remaining time. I know it's not exactly a "timer" but it's close.

 

[Kidmon]

Thank you for your response.
I have already tried your solution my Problem 1. Thank you

Your solution to Problem 2 is not what I hoped for but I THINK I CAN MAKE IT WORK. THANX, it's a great idea. (Maybe my solution?) But I have an error somewhere in the entry of your solution. I paste your solution in column L and I have checked my cell format to match your h:mm suggestion. But I return 0:00 in column J & K. I try to enter the current time but the formula in column L return a values different than 30 min.
Here is a screen shot of what I am doing. What am I doing wrong? Thanx again, Your getting me closer....<table class="html-maker-worksheet" border="1" cellpadding="0" cellspacing="0"><thead><tr><th></th><th>DDAF Form<table class="html-maker-worksheet" border="1" cellpadding="0" cellspacing="0"><thead><tr><th></th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th></tr></thead><tbody><tr><th>6</th><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Taken / Declined</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Officer no.</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Time Going Out</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Time Back In</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> Total Time Out</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Time Left</td></tr><tr><th>7</th><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><th>8</th><td></td><td></td><td></td><td style=";">0:00</td><td style="text-align: center;;">0:00</td><td style="text-align: right;;">4:27</td></tr><tr><th>9</th><td style="text-align: center;;">N/A</td><td></td><td></td><td></td><td></td><td></td></tr><tr><th>10</th><td style="text-align: center;;">Taken</td><td></td><td></td><td></td><td></td><td>Excel 2010

Cell Formulas
Range	Formula
K8	=IF(J8-I8=0,"",J8-I8)
L8	=J8+TIME(0,30,0)-(NOW()-INT(NOW()))

</th></tr></thead><tbody><tr><th></th><td style="word-wrap: break-word"></td></tr><tr><th></th><td style="word-wrap: break-word">

 

[RonB1111]

The sample data in your 1st post had the Time Out in J8. You're 2nd post has it in Col I and I8 is blank. The formula is looking for the starting time in J8, so change J8 in the formula to whatever cell you have the Time Out entry.