Convet DateTime in Google Drive
IFTTT
DATA
B3
"November 09, 2016 at 09:49PM"
MESI!A1:B13
| SMESE | NMESE |
| November | 11 |
| December | 12 |
FUNCTIONS
Calcolo Orario TIME
=TIME(LEFT(LEFT(RIGHT(B3;7);5);2)+IF(RIGHT(B3;2)="PM";12;0);RIGHT(LEFT(RIGHT(B3;7);5);2);0)
Calcolo Data DATE
=DATE(LEFT(RIGHT(B3;15);4);VLOOKUP(LEFT(B3;LEN(B3)-20);MESI!$A$1:$B$13;2;FALSE);LEFT(RIGHT(B3;19);2))
