convert hours, minutes, am/pm to time

[OldOne]

I am developing a time log spreadsheet that allows the user to pull down 3 lists for 3 different cells. For instance: the user clicks on cell A1 and selects a start time in hours from a list. In cell A2 he selects the start time in minutes. And in cell A3 he selects AM or PM. I wish to concatenate/combine these in cell A4 to a standard excel time format. (I wish the start time in A4 to appear as 2:34 PM, for example) Whatever the resulting format, the time in A4 must be able to be used in additional time study equations. What is the best way to achieve that goal?

 

[edokhotnik]

Format A4 as Time and use

Excel Workbook
	A
1	10
2	30
3	AM
4	10:30 AM
Sheet1

Excel 2010

Cell Formulas
Range	Formula
A4	=A1&":"&A2&" "&A3

HTH, Ed

 

[OldOne]

Thank you. I'll give that a shot.