In Zohon Reports how to extract the time from a date & time column?

In Zohon Reports how to extract the time from a date & time column?

By using a formula columns you can separate date & time. 

1. Login to your Zoho Reports account. 
2. Go to the corresponding table. 
3. Change the date format of the date column as dd-MM, yyyy HH:mm:ss
4. Click Ok. 
5. Click Add > Custom Formula.
6. Enter the Formula Column name as Time to derive the time.
7. Add the below mentioned formula 

concat( if( hour( "Date")  < 10, concat('0',hour("Date")), hour("Date")), ':',if(minute("Date") < 10, concat('0',minute("Date")), minute("Date")), ':', if(second("Date") < 10, concat('0',second("Date")), second("Date")))

Note : You can replace the base date column name instead of Date, which we used as an example. 

8. Click Ok. 
9. As a result the time from the date column will be listed in separate column.