can I get values (time) of two same values in accedning order with two
Criteria.
for example I have employee code / date & time
now employee code repeates two or more times in a day with diffrent times.
now what I want if I select parcticular date with particular empoyee ID then
time of that particuar date or day should reflect in acceding order in
single cell.
EMPCode Date Time
5 25/09/11 09:15:30
5 25/09/11 12:30:00
5 25/09/11 18:30:45
taking above table as an example I want result in following format.
EmpCode - 5
Date - 25/09/11
25 (09:15:30 | 18:30:45)
means start time and end time for the day or date should reflect.
the idea behind is to creat a caleder for attendence with time for employee,
on the basis of data which is imported from biomatix system.
kindly help me out
vikas daiya
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
