How to use REGEXEXTRACT for day and time?

Question

I am using a third-party app that allows me to log in my day, time and location at the push of a button, on a google sheet.

_{(source: imggmi.com)}

While the app catches these three elements (day, time, and location), I can only see day and location because of the formula that is being used.

_{(source: imggmi.com)}

Is there a way to modify the formula to display both the date and time?

Here it is: https://docs.google.com/spreadsheets/d/13-1TjKYkBzcVCnWP7Yxejf2U9hem6RHeJFFpiDAazDk/edit?usp=sharing — ASE, Jun 15 '19 at 15:07

player0 · Accepted Answer · 2019-06-15T15:28:30.267

1

=TO_DATE(DATEVALUE(REGEXEXTRACT("June 14, 2019 at 11:52AM", "\w+ \d{2}, \d{4}"))+
         TIMEVALUE(REGEXEXTRACT("June 14, 2019 at 11:52AM", "at (.*)")))

edited Jun 15 '19 at 15:28

answered Jun 15 '19 at 15:12

player0

124,011
12
67
124

How to use REGEXEXTRACT for day and time?

1 Answers1