Calculate average time

Change the formula in H4 to this:

=G4-F4

Use Format Cells to set the format on that cell to Custom as [h]:mm, then copy the formula down. Your average comes out as 11:10.

Hope this helps.

Pete

Thanks Pete
feel a bit stupid now, can I make it ignore gaps in the data, as previously I have been manually deleting them