How many hours in total from multiple start & end times

Hey,

So I have a list of appointment start times and end times
I am after a way to find the time from the start of the first appointment to end of the last (to work out how long the day was)

I've attached an example worksheet

Thanks

Callum

After playing around I can get it to work if I look at just the day with;

{=(MAX(IF(DAY(B2:B9)=DAY(G4),B2:B9)))-(MIN(IF(DAY(A$2:A$9)=DAY(G4),A2:A9)))}

but would be great if I could get it to work with the whole date

=lookup(g4+0.9999,$b$2:$b$9)-index($a$2:$a$9,match(g4,index(int($a$2:$a$9),),))

The following as an array that you appear to be familiar with gets rid of the day function

=MAX(IF(A2:A9>G4,IF(A2:A9<G4+1,B2:B9,"")))-MIN(IF(A2:A9>G4,IF(A2:A9<G4+1,A2:A9,"")))

Perfect davsth, Thanks!