Hi All!
I have a unique google sheet formula that a very kind person created for me. My issue is I need to see if there is a way to get this formula to work in excel. Now the interesting thing is it looks like the formula ALMOST works. If you put a ' in front of this formula it works, however the formula stays in the cell that we put it in. For example we have are putting this formula in K2 and the data populates in K3-K52, but the formula stays in K2 instead of how it works in google sheets where the formula moves to the background and the data populates in the cell.
I'm not sure if that's just a compatibility issue or what.
Here is the google sheet formula:
=BYROW($J$2:$J,LAMBDA(d,IF(d="",,SUM(MAP({1440,60,1},{"d","h","m"},LAMBDA(m,t,m*IFERROR(REGEXEXTRACT(d,"(\d+)(?: "&t&")"))))))))
Here is a link to the excel spreadsheet
