please help me to find a formula to calculate overlaping times by day
01/01/2014 10:00 10:30
01/01/2014 11:00 12:00 -----overlap 11:00 11;30
01/01/2014 11:00 11:30 -----
01/01/2014 12:00 14:00
01/01/2014 15:00 18:00 ------------overlap 16:00 17:00
01/01/2014 16:00 17:00 ------------
02/01/2014 22:00 23:00
thaks for any help in advance
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
02/01/2014
........
.....
Hi,
Welcome to the forum.
It would be really helpful, if you could post a sample workbook and how your output needs to look like along with a brief explanation of what you need.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Pl see attached file with formula.
Last edited by kvsrinivasamurthy; 05-26-2014 at 07:21 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks