View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lsililai lsililai is offline
external usenet poster
 
Posts: 1
Default Summing up times by key words in diff column

I have 3 columns: Date|Time|Activity.

26-Oct-06 13:20 Sanity Testing on File Maintenance.
14:00 Stopped.
14:15 Resume Sanity Testing.
15:00 Stopped.

I want to calculate timing per date based on Activity "STOPPED". Say every
date, if last column=STOP, total time in minutes should be calculated
accordingly in that row across.

Actually, I want to automate a manual log spread sheet