Summing up times by key words in diff column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lsililai - 14 Sep 2007 07:24 GMT

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

Reply to this Message

Max - 14 Sep 2007 08:30 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I have 3 columns: Date|Time|Activity.
>
[quoted text clipped - 8 lines]
>
> Actually, I want to automate a manual log spread sheet

Reply to this Message