I have a user form for entering several date and time information. For ease of data entry I'd like to utilize the date and time picker in Excel 2010. I want the user to click on a "Date" button in field A and have the date picker pop up and they can select the date and have it populate field A. Then they would move to the next fiield click on the "Date" button and they can select the date and have it populate filed B. Here are my questions:
1. What is the best way to accomplish this?
2. Since I will be calculating durations is it best to enter the date and time in one field or do it seperate fields.
Hope this helps.