Linking 2 cells together so if you select one cell the second cell will have answer

[cheri]

Hello,

I am trying to prepare a spreadsheet that will have 2 cells linke
together. The first cell is a drop down window showing time from 1:0
PM to 12:00 PM. Once the individual selects the 1st cell the secon
cell should appear with the correct military time. For example, A1 2:0
PM was selected and B1 will show 14:00.

How can I do this??

Thank you so much for your help,
Cher

 

[JE McGimpsey]

One way:

B1: =A1

Format B1 with Format/Cells/Number/Time and choose the 24 hour time


Note that 14:00 is really *not* military time (for one thing, military
time doesn't have a ":" in it)

 

[Debra Dalgleish]

You can use Data>Validation to create the dropdown list. There are
instructions in Excel's Help files, and here:

http://www.contextures.com/xlDataVal01.html

In the next cell, enter a formula to return the time from the original
cell. For example, if the data validation list is in cell A2, enter this
formula in B2: =IF(A2<>"",A2,"")

Format cell B2 in military time (Format>Cells, Number tab, Time)