Summing up times by key words in diff column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Negative Dates and/or Times 3
Time Sum in Excel 1
Lookup and average data in an unsorted list 1
Return Time for Duplicate Files & Times 4
Sum amounts based on date field 6
Peak call times/hours 2
If statement to compare time cell to a time 9

Back
Top