help. formula for computing time difference

[bracky]

I am computing for time difference between 2 columns. Column A represent the "SCHEDULED TIME IN" and column B represent " REAL TIMED OUT" (time when an employee clocked out). Column C represent the result. I am using the formula =B1+(A1>B1)-A1. The formula is perfectly fine in some areas. However if B1 is lesser than A1 the results is not correct.

Example:

SCHEDULED TIME IN A1 2:00 pm
REAL TIMED OUT B1 1:08 pm
Result C1 23:08

The result should be 0:52:00. Please give me advised on what to do.

Thanks

 

[bracky]

I got the answer to my question. Since the result keeps on adding 24 hours, I put 24- in the formula.

Something like this =24-(E5+(D5>E5)-D5)

Thanks anyway to some of you who wants to help me. I hope this will help someone who have the same query.