Format Calculated Field as Time

Hi Vera,
Thank you for your prompt answer.
It's an acceptable solution up to a certain point.
If the time pattern can be saved into the json config that allows us to customize the pivot (under the options section), the customizeCell function is NOT part of that config, which means that we require custom coding on the specific report (on the web project that builds the flexmonster web page).
You should think of adding that to the json config, the replacement customizeCell function, since it really targets that one report. That way, the json config would totally take care of the report looks, which is ultimately what you'd want from a config file.
Thank you again.

Also, why wouldn't we have the custom date/time format available in the UI just like we have the number formats? And maybe other formats, regex based.

I hope this helps someone, maybe even the Flexmonster team when they will add the customizeCell function to the common config (hint :)).
The only way I could pass the dynamic cellCustomize function body to flexmonster was by adding .bind(this) to the dynamic javascript function created with: new Function('param1', 'param2' , 'javascript code for function body')
If you don't do the .bind(this), typescript will not let you compile, since the signature of the dynamic java function you create with new Function() is not the same with the param of the flexmonster.customizeCell method.
My code, Angular 7, looks like below, where the customCell property holds the dynamic javascript code that I read from a database.

...
this.customCell=this.decodeHtml(this.customCell);
this.onCustomizeCellAlternative= (new Function('cell', 'data', this.customCell)).bind(this);
this.pivot1.flexmonster.customizeCell(this.onCustomizeCellAlternative);

 
Again, this is needed to compensate the fact that the json config a custom report offers doesn't contain enough to allow advanced manipulation of the cells contained in the flexmonster report.
The advanced code can be added by the customizeCell function handler. If you want to complement the json config, specific to ONE report, with the customizeCell config, persist the customizeCell javascript code on the side of the json config, and then load it dynamically as in the instructions above.
 
I am also showing below some sample templates for the customizeCell code that you might want to use:
 

customizeCellTemplate: `
//template 1
if (data.type === 'value' && data.measure && data.measure.uniqueName === 'Formula #1') {
var h = Math.floor(data.value / 3600);
var m = Math.floor((data.value - h * 3600) / 60);
var s = Math.floor(data.value - h * 3600 - m * 60);
cell.text = h + ':' + m + ':' + s;
}

//template 2
const hierarchy = data.hierarchy;
if (hierarchy && data.label) {
if (data.type === 'value') {
if (hierarchy.caption === "Supplier Name") {
var id = JSON.parse(data.recordId);
cell.text = '<a href="/' + id.id + '/'+ id.parentId + \`">\${data.label}</a>\`;
}
}
}

//template 3
if (data.type === 'value' && (data.label === '' || data.label === '[object Object]')) {
cell.text = '';
} else
if (data.type === 'value' && data.label === 'Infinity') {
cell.text = '0.00%';
} else
if (data.type === 'header' && data.label === '[object Object]') {
cell.text = '';
}
if (data.type === 'value') {
if (data.rowIndex % 2 === 0) {
// cell.addClass('alter1');
} else {
cell.addClass('alter2');
}
}
if (data.type == 'value') {
//&& data.measure.uniqueName == 'test') {
if (isNaN(data.value)) {
cell.text = 'N/A';
}
}`

Also, if you want to debug the dynamic code you assigned for the customizeCell function, add, as the last line in the code, this comment:

//# sourceURL=customizeCell.js

 
See attachment screenshot on how that looks like.