login and logout time , with total login time ,break> 1 hours

hi,

i am looking for macro or vb for below data with

1. login and logout time
2.total login time each agent for the day
3.taken more then 1 hours break for the day agents wise

Name Date Log in Time IN/OUT Log in Time 1 IN/OUT 1 Office - Intime
Sindhu 1-Aug-13 10:00 in 10:45 out 0:45
Sindhu 1-Aug-13 11:00 in 13:30 out 2:30
Sindhu 1-Aug-13 14:30 in 19:00 out 4:30
Sindhu 2-Aug-13 9:30 in 11:00 out 1:30
Sindhu 2-Aug-13 11:10 in 12:30 out 1:20
Sindhu 2-Aug-13 13:30 in 15:00 out 1:30
Sindhu 2-Aug-13 15:05 in 16:30 out 1:25
Sindhu 2-Aug-13 16:45 in 19:10 out 2:25
Sindhu 3-Aug-13 9:45 in 11:00 out 1:15
Sindhu 3-Aug-13 11:05 in 12:45 out 1:40
Sindhu 3-Aug-13 13:45 in 19:00 out 5:15
Sindhu 4-Aug-13 9:50 in 11:30 out 1:40
Sindhu 4-Aug-13 11:30 in 13:00 out 1:30
Sindhu 4-Aug-13 14:00 in 19:00 out 5:00
Nirm 1-Aug-13 10:00 in 10:45 out 0:45
Nirm 1-Aug-13 11:00 in 13:30 out 2:30
Nirm 1-Aug-13 14:30 in 19:00 out 4:30
Nirm 2-Aug-13 9:30 in 11:00 out 1:30


can any one modify the macro to get the login and logout time for each agents by date below

Please Login or Register  to view this content.