so I'm confused as to how to take the auto-populated string "01/18/2021@19:00 (CST)" into a valid Date/Time format.

I know that I should be using Date formula but am unable to program this correctly. Any help would be greatly appreciated.

Extra Homework:

Once this is done, I'd like google sheets to compare that time to real time and send me an email notifying me that the time is within 15 minutes of the noted time.

  • 1
    Welcome. What have you tried so far? Also. What are your expected results? Jan 18, 2021 at 22:10
  • End Result: I desire for Google sheets to notify me once a particular job is within 15 minutes of starting. I need to cell to automatically transfer a string into a valid date/time so that I can compare that to real time. The email aspect will obviously be secondary if possible at all. Jan 20, 2021 at 0:48

1 Answer 1


If string is in the B2 Cell


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.