Hi all,

In Microsoft Excel 2010, does anyone how we can convert week or day numbers into its correct format?

For example, if the answer is 9.8 in cell X. Cell X being weeks.

9.8 is 9 weeks 5 days 14 hours and 24 minutes.

Or 68.6 days.

How do we get the answer 9.8 (weeks) to display as “9 weeks 5 days 14 hours and 24 minutes” or 68.6 (days) as “9 weeks 5 days 14 hours and 24 minutes”?

Many thanks.

Gtz101