Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
sri sri is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding rows based on no of rows specified from a given position nanette Excel Worksheet Functions 1 July 9th 08 02:29 PM
Adding five new rows every 40 rows in a spreadsheet? Olzki Excel Discussion (Misc queries) 8 May 18th 07 02:14 AM
Adding Rows offsets to working rows across two worksheets tom Setting up and Configuration of Excel 3 July 30th 06 07:54 PM
Help!! I have problem deleting 2500 rows of filtered rows!!!! shirley_kee Excel Discussion (Misc queries) 1 January 12th 06 03:24 AM
Help!!! I have problem deleting 2500 rows of filtered rows shirley_kee[_2_] Excel Programming 1 January 12th 06 03:15 AM


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"