Hi
I have a worksheet with data (ACTIVITY, START_DATE, END_DATE). I will have 10 000 records. I need to do a table with time intervals (00:01-00:15, ... , 23:45-23:59) with frequency of my data. For example: 00:01-00:15 - 5 activities , 00:16-00:30 - 3 activities etc. Activities may by long and include in several time intervals.
I attach worksheet and please help.
Bookmarks