Hi,

I have uploaded an excel which has timestamp "30 Apr 2018 - 10:27 am" of this format. I need to separate date & time. How will I do it in ZOHO? 

Also, after making the changes when we upload the new data which has the same old format ("30 Apr 2018 - 10:27 am" ), it should auto update to new format. 

Can somebody please tell me how?