Extract length of time and subtract from date/time cell value

[RConner7]

I’ve been struggling with how to start and get this done. I have a column that contains a length of time that could be worded like: 53 seconds ago, 2 hours ago, 1 minute ago. Then I have a column that has the date/time the data was extracted.

I need to be able to subtract the column that has the length of time “ago” from the date/time the data was extracted to give me the exact date/time the row was added.

 

[Rick Rothstein]

I have a column that contains a length of time that could be worded like: 53 seconds ago, 2 hours ago, 1 minute ago.

Will the column ever have mixtures of those values? For example...

5 minutes and 24 seconds ago

1 hour and 43 minutes ago

2 hours, 15 minutes and 5 seconds ago

and so on.

 

[RConner7]

I've added some sample data to how it would look in the excel sheet. I would want to subtract the length of time within the 'SoldWhen' column from the Date/Time in the 'Time' column:

SoldWhen	Time
Updated 13 seconds ago	3/17/2018 11:00:12 AM
Updated 20 seconds ago	3/17/2018 11:00:12 AM
Updated 22 seconds ago	3/17/2018 11:00:12 AM
Updated 23 seconds ago	3/17/2018 11:00:12 AM
Updated a minute ago	3/17/2018 11:00:12 AM
Updated a minute ago	3/17/2018 11:00:14 AM
Updated a minute ago	3/17/2018 11:00:15 AM
Updated 2 minutes ago	3/17/2018 11:00:15 AM
Updated 2 minutes ago	3/17/2018 11:00:16 AM
Updated 2 minutes ago	3/17/2018 11:00:16 AM
Updated 43 minutes ago	3/17/2018 11:02:41 AM
Updated 43 minutes ago	3/17/2018 11:02:42 AM
Updated 49 minutes ago	3/17/2018 11:03:06 AM
Updated an hour ago	3/17/2018 11:04:04 AM
Updated an hour ago	3/17/2018 11:04:04 AM
Updated an hour ago	3/17/2018 11:04:05 AM
Updated an hour ago	3/17/2018 11:04:05 AM
Updated 2 hours ago	3/17/2018 11:09:34 AM

<tbody>
</tbody>

 

[RConner7]

Or... how can I conver the cells in that column from “26 seconds” to 0:00:26 and “25 minutes” to 0:25:00. Maybe that’s somewhere to start.