PM is not entered

i have import data from excel to web application.So i have time field in excel like this 3:00 PM when i run my workflow PM is missing i got 3:00 this only how to get PM is there any condition please help me.

Thanks in advance.

Hi @manogna

Use Cdate(row(“Date”).ToString(“dd/MM/yyyy hh:mm:ss:tt”)

Ashwin S

when i use that condition i got this error, option strict on disallows implicit conversion from ‘string to integer’

if possible can we change that column type alone to TEXT in excel itself so that we will be able to get the whole text here in uipath