Subtracting time

[Caribeiro77]

Hy guys i want subtract the following:

7:00PM
11:00PM

Is easy to know the result in this case, i just have to subtract the later hour by the earlier and i have the result of 4.
But what i want to know how is how to subtract time only after 10:00PM, in this case the result would be 1 hour, i just don´t know how to get it..

Thanks

 

[CWatts]

There are a couple of ways:

=A2-"10:00 PM"

or

=A2-22/24

(since 10pm is 22 hours out of 24)

 

[Toonies]

try this

=IF(COUNT($A1,$B1)=2,MAX(0,MIN($B1+($A1>$B1))-MAX($A1)),0)*24

 

[T. Valko]

Hy guys i want subtract the following:

7:00PM
11:00PM

Is easy to know the result in this case, i just have to subtract the later hour by the earlier and i have the result of 4.
But what i want to know how is how to subtract time only after 10:00PM, in this case the result would be 1 hour, i just don´t know how to get it..

Thanks

Try this...

=MOD(B1-IF(A1 < TIME(22,0,0),TIME(22,0,0),A1),1)*24<TIME(22,0,0),TIME(22,0,0),A1),1)*24< p>

Format as General or Number

 

[Datsmart]

Looks like you have received a number of answers, but I will add mine too.

Excel Workbook
	A	B
1	7:00 PM	11:00 PM
2	11:00 PM	1:00 AM
3	4:00	2:00
Sheet

 

[Scott Huish]

Datsmart, the op only wanted to count time after 11:00 PM.

Which of course begs the question, when does the op consider after 10 PM to stop?

 

[Caribeiro77]

Thanks Valko, i just had to eliminate the last part of the formula "*24" and it's perfect...
thanks once again

Try this...

=MOD(B1-IF(A1 < TIME(22,0,0),TIME(22,0,0),A1),1)*24<TIME(22,0,0),TIME(22,0,0),A1),1)*24< p>

Format as General or Number

 

[T. Valko]

Thanks Valko, i just had to eliminate the last part of the formula "*24" and it's perfect...
thanks once again

You're welcome. Thanks for the feedback!