Dear all, please help for attendance check purpose
I would like to convert data in Excel from below
29/04/2011 09:27 C/In
29/04/2011 13:57 C/Out
29/04/2011 14:23 C/In
29/04/2011 21:19 C/Out
01/05/2011 09:33 C/In
01/05/2011 21:27 C/Out
02/05/2011 09:27 C/In
02/05/2011 20:07 C/In
Into
29/04/2011 09:27 13:57
29/04/2011 14:23 21:19
01/05/2011 09:33 21:27
02/05/2011 09:27 20:07
Can anyone help please ?
Thanks in advance.
Bookmarks