Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in adding rows
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#........ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in adding rows
If you need C# programmes you are in the wrong newsgroup.
-- Cheers Nigel "sri" wrote in message oups.com... 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#........ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding rows based on no of rows specified from a given position | Excel Worksheet Functions | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
Help!!! I have problem deleting 2500 rows of filtered rows | Excel Programming |