LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I implement this in Excel? Need programming tips.

I have an algorithm for a certain program. But I need help
implementing it in Excel. Here is my algorithm:

1. Take the start time (user inputted): ex. 10:03:05
2. Put it in column A, row 2
3. Add 9 seconds to start time: ex. 10:03:05 + 0:0:09 = 10:03:14
(new_time1)
4. Put new time in Column B, row 2
5. Write down "Event 1" in Column C, row 2.
6. Add 1 second to new_time1 (ex: 10:03:14): ex. 10:03:14 + 0:0:01 =
10:03:15 (new_time2)
7. Put new_time2 in column A, row 3.
8. Repeat steps 3 to 6 (incrementing new row in step 6) until end time
is reach (end time is hard coded).


Also, on step 5, I'd like to be able to change Event 1 to Event 2 for
each consecutive row.

Any tips?
TIA!

 
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
Implement Hyperlink in Excel Worksheet using c# shantanu Excel Worksheet Functions 0 March 9th 07 10:14 AM
Need some general Tips and Tricks for programming ! Bill Case Excel Programming 11 September 29th 06 11:36 PM
How do I implement if-else functionalilty for a cell in excel? Raja Suman Excel Programming 3 September 14th 06 06:25 AM
Tool tips or screen tips Andrew B[_4_] Excel Programming 0 April 27th 06 07:40 AM
How do I,implement a recurssive loop using Microsoft Excel ? Vikas_Yadav Excel Programming 1 August 10th 05 07:14 AM


All times are GMT +1. The time now is 02:49 PM.

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

About Us

"It's about Microsoft Excel"