Forum Discussion
megbennett
Jan 06, 2022Copper Contributor
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...
Jovanny315
Aug 02, 2022Copper Contributor
megbennett Check out the solution here Convert datetime text to days (including decimals) - Microsoft Community