Forum Discussion
Solved
Building a formula for Hours and minutes needing an IF Statement - probably
The information is being exported to Excel from another platform. Last Name First Name Hours/Quantity Minutes Smith Jane 1 hr. 30min Smith John 7 hr. McDonald Ron 30min...
=LET(hpos, SEARCH("hr.", C2), hours, IF(ISNUMBER(hpos), LEFT(C2, hpos-1), 0), mpos, SEARCH("min", C2), minutes, IF(ISNUMBER(mpos), MID(C2, mpos-2, 2), 0), 60*hours+minutes)
=LET(hpos, SEARCH("hr.", C2), hours, IF(ISNUMBER(hpos), LEFT(C2, hpos-1), 0), mpos, SEARCH("min", C2), minutes, IF(ISNUMBER(mpos), MID(C2, mpos-2, 2), 0), 60*hours+minutes)