Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate time by using a drop down
Hi,
I'm in the process of automating a daily count sheet. What I want is: If I select a particular activity from a drop down it should give me the system time; basically it would help to calculate how much time a person has spent on that activity. Eg: If I select Activity A from the drop down it should give me the system time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate time by using a drop down
Take a look he
http://www.mcgimpsey.com/excel/timestamp.html In article , DD wrote: Hi, I'm in the process of automating a daily count sheet. What I want is: If I select a particular activity from a drop down it should give me the system time; basically it would help to calculate how much time a person has spent on that activity. Eg: If I select Activity A from the drop down it should give me the system time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate time by using a drop down
Thanks, that was great!!
"JE McGimpsey" wrote: Take a look he http://www.mcgimpsey.com/excel/timestamp.html In article , DD wrote: Hi, I'm in the process of automating a daily count sheet. What I want is: If I select a particular activity from a drop down it should give me the system time; basically it would help to calculate how much time a person has spent on that activity. Eg: If I select Activity A from the drop down it should give me the system time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a drop-down list along with an auto-populate drop-down | Excel Discussion (Misc queries) | |||
drop down then populate | Excel Discussion (Misc queries) | |||
Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
Populate Drop Down List | Excel Worksheet Functions |