Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an excel sheet in which rows will look below
---------------------------------------------------------------------------*--------------- ACTIVITY STARTTIME STOPTIME TOTALTIME ---------------------------------------------------------------------------*------------------- srikanth 11/2/2006 11.46 11/2/2006 11.48 0.02 ravikanth 13/2/2006 11.48 11/2/2006 11.50 0.02 srikanth 14/2/2006 10.48 11/2/2006 11.48 1.00 ravikanth 15/2/2006 10.30 11/2/2006 11.00 0.50 i want to merge two rows if the activities have the same name....and add the totaltime for those two activities..that means that output should look like below which i will save in another excel file. ------------------------------------------- ACTIVITY TOTALTIME ---------------------------------------------- srikanth 1.02 ravikanth 0.52 can any one tell how to write a program for that using C#........ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |