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 You could write a formula that breaks down the text string based on the words year, month, weeks, days, hours and minutes. I would favor splitting the text with the help of Text-to-columns and then use several formulae that calculate days and fractions of days.
Example attached.