Hi Joeu,


It turned out that under some conditions the functions, I got from Claus
gave the wrong results...

So, I gave your functions a test-drive, and they worked under every
conditions :-)

So, once again thank you for your time and effort...


CE


Den 26.01.2013 21:06, joeu2004 skrev:
Clarification....
I wrote:
"Charlotte E." wrote:
Now I would like to know (in 3 other cells):
- How many hours are within these clock intervals:
21-23
23-00
00-03
[....]
How to calculate how much time (hours and minutes)
is within each of these 3 intervals???

It is not clear whether you mean only 21:00 to 23:00 and 23:00 to 00:00
on the start day and 00:00 to 00:03 on the end day, or you mean the sum
of time in those intervals on each day.

I interpreted the requirement as the latter.

For example, if the start time is 22:00 and the end time is 21:59 (the
next day implicitly), I count the amount of time between 21:00 to 23:00
as follows:

1h between 21:00 to 23:00 on the start day
plus
59m between 21:00 and 23:00 on the end day

Is that what you want?