Spreadsheet: 142076d1329629171-how-to-calcualate-the-first-login-and-last-log-out-time-time-1-
Sheet: India 

Agent Name | Extn | [NAME] | Logout Time | Logout Date | FormatedLoginTime | FormatedLogoutTime
15087 | 13014 | 10:29AM | 10:44AM | 2012-02-17 00:00:00
15087 | 13014 | 11:03AM | 11:46AM | 2012-02-17 00:00:00
15089 | 64987 | 11:34AM | 12:33PM | 2012-02-17 00:00:00
[NAME] | 63783 | 2:31PM | 11:30PM | 2012-02-17 00:00:00
[NAME] | 13002 | 12:32PM | 9:12PM | 2012-02-17 00:00:00
Anand [NAME] | 64991 | 12:34PM | 6:30PM | 2012-02-17 00:00:00
Anil Rampeesa | 41019 | 2:29PM | 10:42PM | 2012-02-17 00:00:00
Anil Rampeesa | 41019 | 10:43PM | 11:31PM | 2012-02-17 00:00:00
Anirudh M Singh | 61751 | 7:36AM | 4:35PM | 2012-02-17 00:00:00
Ankit Sharma | 61753 | 2:35PM | 11:31PM | 2012-02-17 00:00:00
[NAME] | 64990 | 10:30AM | 7:36PM | 2012-02-17 00:00:00
Arun, G | 61744 | 8:47PM | 1:30AM | 2012-02-18 00:00:00
Arun, G | 61744 | 4:13PM | 8:12PM | 2012-02-17 00:00:00
[NAME] | 65305 | 7:30PM | 11:30PM | 2012-02-17 00:00:00
[NAME] | 65305 | 2:28PM | 7:00PM | 2012-02-17 00:00:00
[NAME] | 65305 | 7:01PM | 7:01PM | 2012-02-17 00:00:00
[NAME] | 65305 | 7:30PM | 7:30PM | 2012-02-17 00:00:00
[NAME] | 61723 | 4:12PM | 1:10AM | 2012-02-18 00:00:00
[NAME] | 61885 | 8:36AM | 11:50AM | 2012-02-17 00:00:00
[NAME] | 61885 | 11:52AM | 3:19PM | 2012-02-17 00:00:00
[NAME] | 61885 | 3:28PM | [NAME] | 2012-02-17 00:00:00
[NAME] | 61885 | [NAME] | 6:23PM | 2012-02-17 00:00:00
Dinesh Putti | 64986 | 12:37PM | 1:54PM | 2012-02-17 00:00:00
Dinesh Putti | 64986 | 1:54PM | 1:55PM | 2012-02-17 00:00:00
Dinesh Putti | 64986 | 1:55PM | 9:40PM | 2012-02-17 00:00:00
[NAME] | 63782 | 2:33PM | 11:30PM | 2012-02-17 00:00:00
[NAME] | 65029 | 7:17PM | 11:30PM | 2012-02-17 00:00:00
[NAME] | 65029 | 2:29PM | 2:29PM | 2012-02-17 00:00:00
[NAME] | 65029 | 2:30PM | 2:42PM | 2012-02-17 00:00:00
[NAME] | 65029 | 2:49PM | 7:17PM | 2012-02-17 00:00:00
Gopalkrishna | 64984 | 4:29PM | 1:33AM | 2012-02-18 00:00:00
Hafeez M Ahmed | 40938 | 5:29AM | 2:31PM | 2012-02-17 00:00:00
[NAME] | 65550 | 10:35AM | 7:30PM | 2012-02-17 00:00:00
Karthik Kumar | 61722 | 11:47AM | 8:24PM | 2012-02-17 00:00:00
Krishna, M B R | 61746 | 9:31PM | 1:41AM | 2012-02-18 00:00:00
Krishna, M B R | 61746 | 4:35PM | 8:48PM | 2012-02-17 00:00:00
Kumaresh M | 61756 | 2:50PM | 11:31PM | 2012-02-17 00:00:00
Lakshmi Swati | 64987 | 9:30PM | 6:30AM | 2012-02-18 00:00:00
Maiyappa, Gangadhara | 13014 | 9:41PM | 9:42PM | 2012-02-17 00:00:00
Maiyappa, Gangadhara | 13014 | 9:50PM | 9:52PM | 2012-02-17 00:00:00
Maiyappa, Gangadhara | 61743 | 9:53PM | 7:08AM | 2012-02-18 00:00:00
Naseem, Fara | 61870 | 7:09AM | 2:31PM | 2012-02-17 00:00:00
Nayak, Sadhana | 13003 | 5:27AM | 2:37PM | 2012-02-17 00:00:00
[NAME] | 61742 | 11:25AM | [NAME] | 2012-02-17 00:00:00
Nischith Suvarna | 61754 | 2:35PM | 11:30PM | 2012-02-17 00:00:00
[NAME] | 61866 | 2:32PM | 11:31PM | 2012-02-17 00:00:00
Prathiba Narasiah | 13001 | 11:15AM | 11:15AM | 2012-02-17 00:00:00
Prathiba Narasiah | 13009 | 11:15AM | 8:24PM | 2012-02-17 00:00:00
Praveen K | 64994 | 10:31AM | [NAME] | 2012-02-17 00:00:00
Prethyush M Dharan | 61743 | 11:00AM | 6:58PM | 2012-02-17 00:00:00
Prethyush M Dharan | 61743 | 6:58PM | 8:00PM | 2012-02-17 00:00:00
Ragina Rajan | 61740 | 7:36AM | 4:32PM | 2012-02-17 00:00:00
[NAME] | 64988 | 12:31PM | 9:30PM | 2012-02-17 00:00:00
Rakesh L D'Souza | 61741 | [NAME] | 12:43PM | 2012-02-17 00:00:00
Ravi Manduru | 61576 | 7:21AM | 12:13PM | 2012-02-17 00:00:00
Ravi Manduru | 61576 | 12:13PM | 4:34PM | 2012-02-17 00:00:00
[NAME] | 13006 | 10:46AM | 7:00PM | 2012-02-17 00:00:00
Sabir Kumar Swain | 63781 | 9:34AM | 6:38PM | 2012-02-17 00:00:00
Sandeep K | 61869 | 2:31PM | 11:30PM | 2012-02-17 00:00:00
Sanoop M | 61750 | 11:06AM | 8:06PM | 2012-02-17 00:00:00
[NAME] | 64985 | 8:26AM | 11:06AM | 2012-02-17 00:00:00
[NAME] | 64985 | 11:07AM | 2:13PM | 2012-02-17 00:00:00
[NAME] | 64985 | 2:18PM | 5:29PM | 2012-02-17 00:00:00
[NAME] | 64983 | 12:25AM | 12:53AM | 2012-02-17 00:00:00
[NAME] | 64983 | 12:53AM | [NAME] | 2012-02-17 00:00:00
[NAME] | 13001 | 9:49PM | 1:44AM | 2012-02-18 00:00:00
[NAME] | 61725 | 7:32AM | 4:33PM | 2012-02-17 00:00:00
Sunil Kumar S | 61748 | 2:34PM | 11:32PM | 2012-02-17 00:00:00
[NAME] | 60532 | 4:45PM | 1:34AM | 2012-02-18 00:00:00
[NAME] | 61740 | 9:29PM | 6:31AM | 2012-02-18 00:00:00
[NAME] | 61728 | 2:31PM | 11:30PM | 2012-02-17 00:00:00
[NAME] | 64998 | 9:23AM | 2:32PM | 2012-02-17 00:00:00
[NAME] | 64998 | 5:29AM | 8:42AM | 2012-02-17 00:00:00