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 |
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) |