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
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.
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')");
15 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.