Hello,
I am trying to get the average length of time for dates that are stored in excel as weeks.days
For example, 36 weeks 6 days is entered as 36.6
As you can see, this is a problem for finding the average! Is there a way to convert 36.6 into 36.86 (because 6 days is 86% of a week), so that I can find an actual average length of time?