View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.