I am trying to import a zoho sheet into zoho analytics. 

In my sheets one of the columns has "time Entries" in this "format HH:MM am/pm" example 11:00 PM. 

After import, i noticed that analytics converted the time to "00 Jan 1900 23:00:00".. 

how do i maintain the time only?