Finding the average of date + time

mlail

I have two columns that i need to take the average of. The two columns are in Date Time format ex. 12/30/18 1:53 AM and 12/30/18 2:08 AM where the average of the two is 12/30/18 2:00 AM.

In excel its just a quick average formula but i have tried multiple ways to get the average and just can't seem to get the formula correct. Is there a quicker way than parsing the columns taking the average than bringing the cells back to date time? 

Average Time question.xlsx

MarqueeCrew

@mlail,

To find the mid-point of two times, try this formula to solve your challenge:

DateTimeAdd([date1],datetimediff([date2],[date1],"seconds")/2,"seconds")

Cheers,

Mark