|It does not work because of how Excel stores TIMES|
In Excel time represents the fractional portion of a 24 hour day.
For example, 6:00 AM is stored as 0.25, or 25% of a 24 hour day,
and, 6PM is stored at 0.75, or 75% percent of a 24 hour day.
So your first request was:
1) 23:45 0:15
0.989583333 0.010416667 <--How Excel stores Time
So this formula worked:
Because C1 had to be BOTH Less the A1 and Greater than B1.
Your new times are:
1) 2:45 4:30
0.114583333 0.1875 <--How Excel stores Time
So we can use this:
Because C1 can be Less than A1 OR greater than B1.