I am working with a phone log which is provided to us automatically by a third party. The Date field for the phone log includes the date and also the time stamp of when a call was initiated.

I would like to analyse trends relating to the time when calls are made. However this is difficult to do as both values are in the same cell.

What I would like to do is configure Zoho Reports to split the data or copy part of the data into a new column.

I have successfully copied the data in the Date column to a new column via a formula. However because of the way I am copying it it is preventing me from changing the format of the cell from YYYY HH:MM:SS to HH:MM:SS.

Is there any straight forward way to achieve this in an automated way?

Thanks in advance.

James