Date Time Replacement In IFTTT with settings and functions

If you need to use google datevalue, timevalue functions in IFTTT, you should change settings.

Selection_086.png

Selection_087.png

You can use arrayformula function without google script.

=ARRAYFORMULA(IF(A2:A<>"",TIMEVALUE(SUBSTITUTE(A2:A," at ", " ")) + DATEVALUE(SUBSTITUTE(A2:A," at ", " ")),""))

nd.png

H2
H3
H4
3 columns
2 columns
1 column
Join the conversation now