Tag Info

New answers tagged


I use this formula to convert the date time values IFTTT spits out to a useful format: =TIMEVALUE(SUBSTITUTE(A1," at ", " ")) + DATEVALUE(SUBSTITUTE(A1," at ", " ")) Where A1 is the cell containing the date string This gives you a decimal number that you can format as "Date Time".

Top 50 recent answers are included