Return the Interval between two timings

[mucah!t]

Hello all,

How do I calculate the interval between 2 decimal timings.

hours between 22.00 and 23.30 [cell A1-B1]
i.e: 15.00 - 01.00 = 01.50

The above is just an example. I like to be able to adjust the parameters when necessary. It also needs to take into consideration hours after midnight.

hours between 22.00 and 06.00 [cell A1-B1]
i.e: 15.00 - 01.00 = 03.00

 

[shg]

I can't make sense of either of your examples.

Maybe this:

      --A-- --B-- --C--
  1   22.00 23.30  1.30
  2   15.00  1.00 10.00

The formula in C1 and down is

=DOLLARFR(DOLLARDE(B1, 60) - DOLLARDE(A1,60), 60) + 24*(B1 < A1)<A1)< font>

 

[mucah!t]

Hello shg,

In the first example the time in is 15.00 and the time out is 01.00
How much time falls between 22.00 and 23.30

A1 = 22.00 B1 = 23.30
A2 = 15.00 B2 = 01.00 C2 = 01.50

 

[shg]

      ---A--- ---B--- --C---
  1    22.00   23.30        
  2    15.00    1.00   1.30 
  3                         
  4                         
  5    22.00    6.00        
  6    15.00    1.00   3.00

C2: =DOLLARFR(MIN(DOLLARDE(B2, 60) + 24*(B2 < A2), DOLLARDE(B1, 60) + 24*(B1 < A1)) - MAX(DOLLARDE(A2, 60), DOLLARDE(A1, 60)), 60)


EDIT: That's a lot of clutter just to avoid entering times in standard fashion:

=MIN(B2 + (B2 < A2), B1 + (B1 < A1)) - MAX(A2, A1)

 

[shg]

Both of those should be wrapped in MAX:

=MAX(0, DOLLARFR(MIN(DOLLARDE(B2, 60) + 24*(B2 < A2), DOLLARDE(B1, 60) + 24*(B1 < A1)) - MAX(DOLLARDE(A2, 60), DOLLARDE(A1, 60)), 60))

=MAX(0, MIN(B2 + (B2 < A2), B1 + (B1 < A1)) - MAX(A2, A1))