Anthony H.
asked on
excel worksheet
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.
I have excel 2010.
Daily-Sheet.xlsx
any help would be greatly appreciated. file is attached. it's all fictious data/names.
I have excel 2010.
Daily-Sheet.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Were you referring to the lunch column? Just put a list validation as 0.5, 1, 2.
ASKER
no that's fine the way it is... i just subtract the lunch value.
i want a drop down like this >
http://www.rondebruin.nl/calendar.htm
but i can't get it to work. can you help?
i want a drop down like this >
http://www.rondebruin.nl/calendar.htm
but i can't get it to work. can you help?
I'm not sure if the control would show on your end, if not, you might want to follow the instructions on how to get it installed.
Daily-Sheet-withCalendar-.xlsm
Daily-Sheet-withCalendar-.xlsm
ASKER