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
|