topic RE: How to convert LocalTime() to 24 hr format as hh:mm:ss ? in Product Forum

How to convert LocalTime() to 24 hr format as hh:mm:ss ?

Tejaskumar_Darji — Thu, 21 Oct 2021 05:51:00 GMT

How to convert LocalTime() to 24 hr format as hh:mm:ss ?

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: How to convert LocalTime() to 24 hr format as hh:mm:ss ?

ewilson — Thu, 21 Oct 2021 11:17:00 GMT

Hi @Tejaskumar_Darji,

I don't think the FormatDateTime() function will accept the output of LocalTime() directly, so you'll probably need to write it to a Text data item. Then you can pass it in to FormatDateTime() with the format "HH:mm" as shown below:

FormatDateTime([Local Time], "HH:mm:ss")

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: How to convert LocalTime() to 24 hr format as hh:mm:ss ?

EmersonF — Thu, 21 Oct 2021 12:21:00 GMT

Trying to contribute and enrich this post, if the date comes from an SQL query in the query itself you can put Format([Column Name], "hh:mm:ss"), but if it's an expression of blue prism what the @ Eric Wilson said it will work for you

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
PAULISTA
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

RE: How to convert LocalTime() to 24 hr format as hh:mm:ss ?

JohnCowell — Thu, 21 Oct 2021 14:15:00 GMT

Although not strictly related, just to add something else to the pot, take a look at the Utility - Data and Time Manipulation VBO to see if any of those actions may be of use. 'UTC To Local' has come in very handy on several occasions.

------------------------------
John Cowell
Senior Software Support Analyst
Blue Prism
------------------------------

Re: How to convert LocalTime() to 24 hr format as hh:mm:ss ?

UAMudrykIh — Thu, 26 Mar 2026 15:55:06 GMT

You can try this expression:

FormatDateTime(Now()+(LocalTime()-UTCTime()), "HH:mm:ss")

Re: How to convert LocalTime() to 24 hr format as hh:mm:ss ?

stepher — Fri, 27 Mar 2026 14:33:50 GMT

Good morning, All, (and this is pertinent in a second).

I feel like I am missing something here, but I believe the following will get you what you are looking for:

FormatDateTime(Today() & " " & LocalTime(), "HH:mm:ss")

It is too early in the morning for the 24-hour indication to trigger, but the time value is valid.

As I said, it is entirely possible that I am not fully awake yet.

Enjoy,

Red