ExcelBanter - AVARAGE TIME

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - AVARAGE TIME (https://www.excelbanter.com/excel-worksheet-functions/229796-avarage-time.html)

raogv

AVARAGE TIME

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

Jacob Skaria

AVARAGE TIME

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

All times are GMT +1. The time now is 11:50 PM.