Dear all,
I am looking for the soltion for this problem for some time now!
Any help is greatly appreciated!
I have a excel file in which time periods are entered as follows (3 columns):
Date/ Start/ End
15.04.2021/09:00/10:00
15.04.2021/10:00/11:00
15.04.2021/12:00/13:00
16.04.2021/13:00/14:00
16.04.2021/14:00/15:00
I need a way to automatically summarize the uninterrupted time periods so that it looks like this (3 columns):
15.04.2021/09:00/11:00
15.04.2021/12:00/13:00
16.04.2021/13:00/15:00
Info:
Windows Version: Microsoft Windows 10 Pro
Excel Version: Microsoft Office Standard 2016
Bookmarks