syedjaveed
New Member
- Joined
- Feb 28, 2013
- Messages
- 37
Hi Team,
Can anyone help me out with how to create a log sheet.
The Log Sheet should contain an employees working time.
how it look like, I Generally have 7 Queues (Log in, Meeting, Break, East Queue, West Queue, Others,Log out) in a range B5 as adrop down list
Just below that i have a start time and end time cells in B6 and B7 (This cells should show the time when the Queues get change).For Example if i select Meeting on 5:10 pm from the drop down (B5) and i changed the queue from meeting to East Queue at 5:50 pm. Which means i have been in meeting for 40mins. Then i have a consolidation area in the same sheet starts from rannge A11 where all the changes should get recorded or updated. Like How much time the associate spend on each Queue.
For Queues Log in and Log out i dont need a End time.
Please find the below snaphot of the sheet (in HTML)
I dont know this HTML code will help u understand my sheet. However please assist as much u can.
Thank You
Can anyone help me out with how to create a log sheet.
The Log Sheet should contain an employees working time.
how it look like, I Generally have 7 Queues (Log in, Meeting, Break, East Queue, West Queue, Others,Log out) in a range B5 as adrop down list
Just below that i have a start time and end time cells in B6 and B7 (This cells should show the time when the Queues get change).For Example if i select Meeting on 5:10 pm from the drop down (B5) and i changed the queue from meeting to East Queue at 5:50 pm. Which means i have been in meeting for 40mins. Then i have a consolidation area in the same sheet starts from rannge A11 where all the changes should get recorded or updated. Like How much time the associate spend on each Queue.
For Queues Log in and Log out i dont need a End time.
Please find the below snaphot of the sheet (in HTML)
| Excel Workbook | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | |||||||||
| 2 | Name | NBK | Person # | ||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | Code | Break | |||||||
| 6 | Start Time | ||||||||
| 7 | End Time | ||||||||
| 8 | |||||||||
| 9 | |||||||||
| 10 | Name | NBK | Person # | Code | Start Time | End Time | Comments | ||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
Sheet1 | |||||||||
I dont know this HTML code will help u understand my sheet. However please assist as much u can.
Thank You
