View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DD DD is offline
external usenet poster
 
Posts: 68
Default 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.