minutes to time format

[#1]

I  got data in minutes(eg 100, 200, 500) i need to convert it to the following format

ah:bmin (eg 5h:20min, 3h:40min).

I tried using interval function

interval(avg([min])/1440,'hh:mm').

I am having 2 problems

1. This expression is executing in chart level, but throwing an error when i use it in the script.

2. I  am getting the output as aa:bb(05:20, 03:40)

[Gysbert_Wassenaar · Accepted solution]

1. If you use avg in a load statement then you need to add all the other fields that are not aggregated in a GROUP BY clause.

2. Try =subfield(interval(avg(min)/1440,'h:mm'),':',1) & 'h' & subfield(interval(avg(min)/1440,'h:mm'),':',-1) & 'min'

[#3]

Just as i needed, Thanks mate,