Assuming the below

A1:A10 = Start Date
B1:B10 = End Date
C1 with the formula (=B1-A1) custom formatted with dd:hh:mm:ss

the average would be =AVERAGE(C1:C10)


If this post helps click Yes
---------------
Jacob Skaria


"raogv" wrote:

HOW TO GET AVARAGE TO THE FOLLOWING
DD:HH:MM:SS
01:12:15:10
00:07:18:00
00:01:25:10
PL ADVISE ANY ONE HOW TO GET AVARAGE TIME OF THE THREE TIMEINGS
THANKS
--
gv