Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Implement Hyperlink in Excel Worksheet using c# | Excel Worksheet Functions | |||
Need some general Tips and Tricks for programming ! | Excel Programming | |||
How do I implement if-else functionalilty for a cell in excel? | Excel Programming | |||
Tool tips or screen tips | Excel Programming | |||
How do I,implement a recurssive loop using Microsoft Excel ? | Excel Programming |