Working hours per day

[Andrea]

I tried to calculate workingtimes per day-

Ok, it's so easy, I thought :-) - but:



        
        
        
        '=(B2-A2)+(D2-C2)       
        Expected
07:00:00        12:00:00        12:30:00        16:30:00        09:00:00        
        09:00:00
07:00:00        12:00:00        12:30:00        
        -07:30:00       
        05:00:00
07:00:00        12:00:00        
        
        05:00:00        
        05:00:00
07:00:00        
        12:30:00        16:30:00        -03:00:00       
        04:00:00

        
        
        
        00:00:00        
        00:00:00

        
        
        
        
        
        

        
        
        
        03:30:00        
        23:00:00

        
        
        
        
        
        


I think i solved the problem a couple of years ago, but I can't remember 
how.

Any ideas?


Thanks and have a nice day

Andrea