Hello Excel Gurus
I'm sure the title is not clear but in this example belowe you will understand better because I wrote the expectd result in Column E and H
As you can see I'd like to know in colum E how many hours are included in the range of time 22:00 / 00:00 n colum H how many hours are included in the range of time 00:00 / 6:00 AM
Thank You for your help
A B C D E F G H 1 From 22:00 From 00:00 2 Till 00:00 Till 06:00 3 IN OUT Result Result 4 23:00 7:00 1:00 06:00 5 22:00 3:00 2:00 03:00 6 20:00 1:00 2:00 01:00 7 8:00 23:00 1:00 8 1:00 5:00 04:00 9 5:00 0:00 2:00 01:00 10 22:00 23:00 2:00 06:00
Bookmarks