Need help grabbing a partial piece of text

Jags0829

I need help with a formula that will successfully split out the Seconds numbers. I have been able to grab the Hours and Minutes but the Second is alluding me. below are the formulas I currently have loaded and are producing the results in the screenshot. The second works MOST of the time but sometimes it cuts off a digit or includes the 's'

Formulas Used

Hours- IF(May@row = "Time", "", LEFT(May@row, FIND("h", May@row) - 1))

Minutes- IF(May@row = "Time", "", MID(May@row, FIND(" ", May@row) + 1, FIND(" ", May@row, FIND(" ", May@row) + 1) - FIND(" ", May@row) - 2))

Second- IF(May@row = "Time", "", MID(May@row, FIND(" ", May@row) + 1, FIND(" ", May@row, FIND(" ", May@row) + 1) - FIND(" ", May@row) - 2))

Paul Newcome

Try this:

=IF(May@row <> "Time", MID(May@row, FIND(" ", May@row, FIND(" ", May@row) + 1) + 1, LEN(May@row) - (FIND(" ", May@row, FIND(" ", May@row) + 1) + 1)))

Paul Newcome

Try this:

=IF(May@row <> "Time", MID(May@row, FIND(" ", May@row, FIND(" ", May@row) + 1) + 1, LEN(May@row) - (FIND(" ", May@row, FIND(" ", May@row) + 1) + 1)))

Jags0829

Nailed it. Thank you, sir.

Paul Newcome

Happy to help. 👍️