AVARAGE TIME

  • Thread starter Thread starter raogv
  • Start date Start date
R

raogv

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
 
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
 
Back
Top