#1
|
|||
|
|||
time capturing
Dear All,
OMR id is 703018994 Password is ahy I want only simple Time tracking sheet through which we can track the time of employee for their each activity doing in office hour. Below the details which reqired in sheet. 1> There should be Start button and by clicking on start button Serial Nmber should come in "A4,(as shown in send excel sheet) and date should be capture in C4, and the time should capture in D4. And then Start button should be inactive till last step( as given in below 3rd point) 2> There should be Done button, and by clicking on that (Done button) time again should be capture in F4, (as end time of one activity) and difference of start time and end time (D4 - F4) should be calculate in G4 (in same format as given in send excel sheet hours:minute:seconds). At same time, time should be capture in D5 again, means end time will be end of one activity and the same will start time for another acitivity. 3> Lastly there should be Submit button and by clicking on submit button all data of current sheet should be move in another sheet. Means whole day activity should be moved in another sheet. Attachment is for ur ref. Rgds, Aligahk06 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook take time | ryangiam | Outlook | 0 | 08-27-2009 06:02 PM |
Using outlook as time tracker? | jtncarter | Outlook | 0 | 06-26-2009 11:59 AM |
Time is killing me!!! | rhale1122 | Excel | 2 | 12-02-2008 09:39 PM |
How to get cells to calculate time? | jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Propose new time issue | cisgoro | Outlook | 0 | 08-10-2006 10:59 AM |