Hi there!
I need a littlee help with excel as I was wondering if my quest was even possible:
Desired Solution:
I want to count the amount of times, a timeframe exists.
Confusing - i Know. thats why I will supply my excel to make sense.
There are two columns counting sleeping time:
Starttime End time
08:15 10:30
12:20 13:45
17:00 18:00
... ...
At the end I want the following solution:
He is sleeping X-times at:
00:01 - 01:00 8 Times
01:01 - 02:00 6 Times
...
...
...
23:01 - 00:00 7 Times
so far I can count how many times he fell asleep between a certain timeframe ("Fell 8 times asleep between 17:01 - 18:00) and also how many times he woke up between a certain time.
What I can not do is count the times in between and i was wondering if anyone has an Idea how to handle this?
BR
hchamala
Bookmarks