Time column to Military Time

Hi Knimers,

I have a question, I have this column:
image

But I need it as military time: (eg. 13:01:01)

I’m using String to Date & Time node, but doesn’t work
.

Any thoughts?

Thanks in advance :slight_smile:

Hi @IvaR
Have you seen this? :thinking:

2 Likes

You’ll need to use the pattern: hh:mm:ss a

Also, ensure to uppercase the strings, because it must be AM/PM for the parser to work.

See here for an example:

2 Likes

Thanks for your answer :slight_smile: but these workflows do exactly the opposite of what I need, I need the time with AM / PM to change to Military, and those workflows do it in reverse

Thanks for answer :slight_smile:

I change all to uppercase:
image

But still doesn’t work :frowning_face:

Any thoughts?

Thanks in advance :slight_smile:

Check the pattern, it must be as follows: hh:mm:ss a (mind the a)

Hope this helps!

– Philipp

2 Likes

It also includes your case. :slightly_smiling_face:
See the workflow I created:
AM PM convertor.knwf (7.8 KB)

4 Likes

Thank you so much :slight_smile: : :+1:

You got the reason!!! Thank you very much for your help and your kind answer :slight_smile: :+1: