Change decimal time format to time

[Edd_0820 (Eddie_wan)]

How can i change below highlighted item to time format (00:00 AM/PM)?

Thank you

RPA|383x499

[aanandsanraj (Anandraj Rajendran)]

Hi @Edd_0820,

Best way change the format in excel itself.

If you want to convert the time using code try the below

DateTime.FromOADate(0.614375).ToString(“hh:mm tt”)

[Edd_0820 (Eddie_wan)]

is it mean change e.g 0.80335648 to datetime first?

[aanandsanraj (Anandraj Rajendran)]

Yeah change the entire column to Time format in excel

[Edd_0820 (Eddie_wan)]

but i want change it in RPA , is it possible?

[aanandsanraj (Anandraj Rajendran)]

Yes possible follow the steps

• Read the excel using Excel activity
• Loop the datatable using ForEach Row activity
• Create a new column as string
• Then assign like below

row("New Col") = DateTime.FromOADate(row("SliceRm In time")).ToString("hh:mm tt")

[yundw]

Convert.ToDateTime(now).tostring( datetime format )
now = “variable”

[Edd_0820 (Eddie_wan)]

@aanandsanraj

“hh:mm tt”)

@yundw

Convert.ToDateTime(now).tostring( datetime format )
now = “variable”

@yundw

Convert.ToDateTime(now).tostring( datetime format )
now = “variable”

Below message is shown

[Edd_0820 (Eddie_wan)]

It is okay now

Thanks