Forum Discussion
Conversion Question
Hello! I need some help with a conversion on Excel. I have a column with data that goes down 25 rows. The values in those cells consists of numbers and texts that display a length of time. For ex...
Let's say those values are in D2 and down.
In another column, enter the following formula in row 2, then fill down:
=IF(ISNUMBER(D2), D2, LET(parts, TEXTSPLIT(D2, " "), IF(COUNTA(parts)=2, --INDEX(parts, 1), 60*INDEX(parts,1 )+INDEX(parts, 3))))
Thank you so much this worked!