how to change a Global Table column (in minutes) to date format

Question

question

Alazne M asked Sep 21, '22 Jeanette F commented Sep 26, '22

how to change a Global Table column (in minutes) to date format

I have created a global table with time data of the items that go through different processors, they are saved in minutes because I do operations between the columns (subtract some times from others), the last column is in minutes and I want to convert it to hours /minutes/seconds format .

I have already determined the start at 8:00:00 and the table is created with the comma

how can i make that change

Software Version:

FlexSim 20.1.3

global table write to global table

· 1

Jeanette F ♦♦ commented · Sep 26, 2022 at 05:00 PM

Hi @Alazne M, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2022-09-21T12:43:08Z

Jason Lightfoot answered Sep 21, '22 Jason Lightfoot edited Sep 21, '22

eg. If your minutes field is called Mins in GlobalTable1 and the target column is 'HMS' of type string:

Table.query("UPDATE GlobalTable1 SET HMS=DateTime(minutes([Mins])).toString('%H:%M:%S')");

question