Just another way:

=CEILING(B2-A2+D2-C2, 1/96)

In article ,
"Bob Phillips" wrote:

If you want to round up a quarter hour, use

=ROUNDUP(((B2-A2)+(D2-C2))*96,0)/96