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

Summing up times by key words in diff column
 

Presuming the activity duration to be calculated is based on the times shown
on the rows with "stopped" less the times in the immediate rows above,
perhaps this might suffice ..

Place in D2:
=IF(B2="","",IF(ISNUMBER(SEARCH("stopped",C2)),B2-B1,""))
Format D2 as time, copy down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lsililai" wrote:
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