View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vito vito is offline
external usenet poster
 
Posts: 37
Default Count how long an event lasted

I have a project worksheet in excel which I use to track various jobs. These
jobs can be in different stages "waiting", "on hold", "in progress". I would
like to track how long the job code is in each of these status. I don't know
if excel can do this, but it would be helpful. Basically, I have a job
number i.e. 3.2 which is linked to a description, starting date and status.
I would like to have a list for each job for the number of days it was in
each status. Any help would be appreciated.

Thanks