428,997 Members | 1,270 Online
Need help? Post your question and get tips & solutions from a community of 428,997 IT Pros & Developers. It's quick & easy.

# Calculate Average Date

 P: n/a Hi all How would I find out the average date when given a bunch of dates? For example, I want to find the average length in time from the following dates: ---------------------------------------------------- Start Date End Date 01/01/2004 12:50pm 02/01/2004 18:40pm 02/01/2004 13:40pm 02/01/2004 13:57pm 02/01/2004 14:30pm 02/01/2004 19:50pm Min = 17 Minutes (2nd entry) Max = 1 Day 5 Hours 10 Minutes (1st entry) Average = ?? ----------------------------------------------------- Also, I have a function that calculates the time difference between 2 dates, but it doesn't work all that well if you take int account months, does anyone have a good function that can take 2 date parameters and return the time difference formatted as '? Months ? Days ? Minutes ? Hours ? Seconds' Thanks for your help, Kind Regards, Steve. Nov 20 '05 #1