Adding 24hr times

[philrobbo]

I am trying to calculate some 24hr times. This is what I have.
I have 4 x times. Start (a), finish (b),2nd start (c) and 2nd finish (d)

If the time difference between b and c is 20mins or less I want e = a + d
If the time difference is greater than 20 mins e = (a + b) +(c + d)

The answer I am looking for is the difference in times. ie 1530 +1545 = 0.15

Please help

 

[Teeroy]

what you actually want then is
e=d-a if c-b<=20 or
e=(b-a)+(d-c) if c-b>20
in formula form, if the times are in A1 trough D1 then in E1:
=IF(C1-B1<=20/(24*60),(D1-A1)*24,((B1-A1)+(D1-C1))*24)

This result is in hours.

 

[philrobbo]

This doesn't seem to work

 

[Teeroy]

It worked for me with basic testing. Can you give an example of a set of times that failed?
Do your times perhaps extend over a day (i.e. start time prior to midnight one day and finish the next day)? If so there's a couple of changes needed.