How can I convert the hh:mm:ss to AM/PM?

[EN6924]

I have a data where there is a column named "Start Date" of String data type

I need to create 2 separate columns based on that record.

1. 11-01-2022 – This should be showing as “Last Backup happened on 11th January 2022” in a separate column.

I did it, kindly give me your opinion that the process is correct or not.

2. How can I convert the hh:mm:ss to AM/PM? For example -

02:00 will show – Backup initiated on 2 AM

00:11:05 will show – Backup initiated on 12:11 AM

09:00:14 will show – Backup initiated on 9 PM

00:00:00 will show - Backup initiated on 12 AM

This should be showing in another column named - "Backup Schedule Time"

Please help

[atcodedog05 · Accepted solution]

Hi @EN6924 

Here is how you can do it.

Workflow:

Hope this helps : )

[EN6924]

Great... It worked perfectly 😊

[atcodedog05 · Accepted solution]

Hi @EN6924 

Here is the optimized version of the workflow

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @EN6924 

If my response helps please don't forget to mark it as solution. 🙂

Cheers and have a nice day!

[EN6924]

By using Table tool - I can able to create border on both side of the column

Can I create a single line border on the entire table? and for header a bold border? Just like we can do in excel -

[EN6924]

I tried changing the dates and found some errors marked in yellow.

Please help me writing the formula properly.

[atcodedog05 · Accepted solution]

Hi @EN6924 

Here is how you can do it.

Workflow:

Hope this helps : )