How to format duration as HH:MM instead of minutes in XRCrossTab

Hello Miroslav,

There is no built-in expression function to format an integer value as a time span. I confirm that you need to write a custom function for this purpose.

For instance, the following function works correctly on my side:

C#
[VSDesignerCustomFunction]
public class MinutesToDuration : ReportCustomFunctionOperatorBase {
    public override string FunctionCategory => "Date & Time";
    public override int MinOperandCount => 1;
    public override int MaxOperandCount => 1;
    public override object Evaluate(params object[] operands) {
        var totalMinutes = double.Parse(operands[0].ToString());
        var hours = (int)(totalMinutes / 60);
        var minutes = (int)Math.Abs(totalMinutes % 60);
        return $"{hours:N0}:{minutes:D2}";
    }
    public override bool IsValidOperandType(int operandIndex, int operandCount, Type type) {
        if (operandIndex >= operandCount)
            return false;
        return type == typeof(double) || type == typeof(double) || type == typeof(int);
    }
    public override string Name => "MinutesToDuration";
}

To register it in your Blazor application, call the CustomFunctions.Register method at application startup before var app = builder.Build();.

Once you create and register this custom function, use it similarly to how I demonstrated in the videos I attached to your other tickets.

Please try this solution and let me know if it helps.

Regards,
Aleksandr