#### mart_mrexcel

##### Board Regular

- Joined
- Aug 23, 2008

- Messages
- 232

1.) How can i have a result as 1.06 (i.e. .06 as the months), instead of 1.6

2.) If in case the decimal reaches the .12, it will add to the whole number so it will be 2

3.) if i have a total years of 1.06 and i wanted to add in 3.10, how can i have a result of 5.04 (i.e. 5yrs and 4 months)

Thanks