Forum Discussion
Converting Year/Month/Week/Day/Hour to Days
Hello, I cannot figure out the formula(s) to convert a single cell that contains '1 Year 8 Months 1 Week 5 Days 17 Hours 30 Minutes' into number of days (would like to round up to a full day, and my...
megbennett Check out the solution here https://answers.microsoft.com/en-us/msoffice/forum/all/convert-datetime-text-to-days-including-decimals/d1766ed6-cd77-41be-b95f-6425a45dbc57