I have an excel workbook (attached). I've been trying to do a calendar drop down to select date in this format "Monday, August 27, 2012" but have not been successfull at all. Also I want to be able to add "time in" + "time out" + luch time (static, 1/2,1,2 hours) = Total hours.
any help would be greatly appreciated. file is attached. it's all fictious data/names.