| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing words | Excel Discussion (Misc queries) | |||
| Why do I lose hundredths when summing elapsed times in a pivot tab | Excel Discussion (Misc queries) | |||
| Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
| Merge words in diff cols to one | Excel Worksheet Functions | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
Linear Mode
