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
Bookmarks