How to get time only in excel column

[Buvaneshwaran_R]

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)

[supermanPunch (Arpan)]

@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

[Buvaneshwaran_R]

@supermanPunch till 2row it’s working after that it’s not working.

[supermanPunch (Arpan)]

@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

[Buvaneshwaran_R]

Thanks @supermanPunch it’s working

[Buvaneshwaran_R]

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

[Pratik_Wavhal]

HI @Buvaneshwaran_R

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

How to get particular value in excel column

Hi @Buvaneshwaran_R Below statement will give the Output in PST DateTime.ParseExact(CDate(row("Date Entered")).AddMinutes(-750).ToString("MM-dd-yyyy HH:mm:ss tt"),"MM-dd-yyyy HH:mm:ss tt",System.Globalization.CultureInfo.InvariantCulture).ToString("HH:mm:ss tt") IST time in Excel (i.e of 1st Row) :- IST = 7-1-2020 12:26:27 am [image] Output in PST (i.e for 1st row value) :- PST = 11:56:27 AM [image] Converted from Internet the same timing :- [image] Workflow for the same :- MainPrati…

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal