Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help for Time tracker updation
Hi,
I have 9 members working on a project and require to track the timings for all. There are 6 columns in the spreadsheet. column 1 contains the type of activity. Column 2 contains the activity start time Column 3 contains the activity end time. I have to ensure the time is tracken completely without their intervention in updating the timings. When they select column 1 first row (type of activity) the Start time should automatically update in Column 2 and when they select the column 1 again in the second row the type of activity, the start time should update in column 2 second row and also the completion time in column 3 first row. Example: Column 1 Column 2 Column 3 Activity 1 05:38 06:37 Activity 2 06:37 08:45 Activity 3 08:45 This is how I am looking the tracker to be. Please help me out in getting the tracker completely. Regards, Igneshwara Reddy. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table updation | Excel Worksheet Functions | |||
Automatic Excel data updation on Sharepoint. | Excel Discussion (Misc queries) | |||
serial updation in locked rows | Excel Worksheet Functions | |||
Automatic date and time updation | Excel Discussion (Misc queries) | |||
updation in farmulae | Excel Discussion (Misc queries) |