I tried another way. In both G2 and G3 of your upload array enter this formula. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.The format according to your upload.
It is as previously stated above. Dates and times are numbers. In cell C2 30.12310185 is the underlying numeric value of 1/30/1900 2:57:16 AM. Formatting is cosmetic. The integer part is the number of full days from 1/1/1900. The decimal portion is the fractional part of a day. For ex: 8/24 is 1/3 of a day. Formatted for time 8:00 AM
=MOD(C2,1) extracts the decimal portions from those numbers in column C and then averages them. Remember to enter with Ctrl + Shift + Enter.
I get
0:11:45:46 (DD:HH:MM:SS)
11:45:46 (HH:MM:SS)
Bookmarks