How to get time only in excel column

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)

1 Like

@Buvaneshwaran_R Please don’t create Multiple posts referring to the same topic :sweat_smile:
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 :sweat_smile: 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

1 Like

@supermanPunch using this output value how can i convert to pst time

HI @Buvaneshwaran_R

Below is the solution for the same
For converting from IST to PST

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer: