I have 2 cells that are in the format line of

A1: 27/06/2006 9:42:00 pm
B1: 7/06/2006 9:52:05 pm

Want third column C1: 00:10


I wish to subtract the two cells to get the difference in time i.e 10:00
(only interested in nearest minute)

Then a average at the end of the column of the the times in this 3rd column
as a result of the difference between the 2 times.

How would I do this?

I could do it if it was just numbers but once it is in this time/dtae format
I am completely lost!

Thanks
MIke