tcarwardine
New Member
- Joined
- Jul 13, 2016
- Messages
- 26
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
I have been given a sheet of ages and asked to calculate the average. However the ages are in decimals e.g. 10.04 = 10 years and 4 months, 11.11 = 11 years and 11 months.
Any ideas how to calculate an accurate average in excel?
I have been given a sheet of ages and asked to calculate the average. However the ages are in decimals e.g. 10.04 = 10 years and 4 months, 11.11 = 11 years and 11 months.
Any ideas how to calculate an accurate average in excel?