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?
Solved! Go to Solution.
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