Doing math on multiple columns

[carlos_villegas]

I have several columns that take in minutes and converts them to hours:minutes format. Now about 4-6 columns are formatted data using the math FLOOR(T/60) for the hour and MOD(T,60) for the minutes. Here’s what I want to do I want to be able to replace T with the 4-6 columns take in minutes as input without having to create a separate math column for each one is there a shortcut around this?

If you need me to explain more let me know

[ThinhDinh]

So you have 4-6 columns in minutes format and want to convert them to hours:minutes format without having to create 3 extra columns for each of them?

[carlos_villegas]

Yes that is correct is there a shortcut around this?

[ThinhDinh]

First option for you: record them in seconds instead of minutes and use this.

Second option: use JavaScript.

const hours = Math.floor(p1 / 60);
const mins = p1 % 60;

return `${hours.toString().padStart(2, '0')}:${mins.toString().padStart(2, '0')}`;

[carlos_villegas]

Thank you so much this just saved me the hassle I didn’t even know you could use JS