Hi all, i have one excel file in that column name Date entered I need to get only time in that column i tried DateTime.ParseExact(row(“Date Entered”).ToString,“M-dd-yyyy HH:mm:ss tt”,CultureInfo.InvariantCulture).tostring(“HH:mm tt”) it’s not working. I have attached that file also can you help to solve this issue.Book4.xlsx (114.7 KB)
@Buvaneshwaran_R Please don’t create Multiple posts referring to the same topic
This format “M-d-yyyy hh:mm:ss tt” worked for me though
@supermanPunch till 2row it’s working after that it’s not working.
@Buvaneshwaran_R Yes. That is correct Sorry.
This should work definitely. “M-d-yyyy h:mm:ss tt”
I just checked it for all the rows now
Thanks @supermanPunch it’s working
@supermanPunch using this output value how can i convert to pst time
Below is the solution for the same
For converting from IST to PST
Mark as solution and like it
Er Pratik Wavhal