Thanks, It worked, but there is one argument, if there are more then three entries in a particular day i.e. on 1st of sept there are three diffrent times mentioned or more than that, then very first and very last time should reflects. (means in time of morning and out time of evening) I have highligthed cell in attached format. the argument is that in a single day more than two entries could be enter.
-- ---------------------------------------------------------------------------------- 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
attensolutionvkey.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
