Data conversion: minutes to hours (mm to hh:mm)

[#1]

Greetings!

Another seely issue... how can I do the data convertion proposed below?

Minutes
------------------------
240
135
-120

TO

Hours
------------------------
04:00
02:15
-02:00

I tried to divide it per 60 and change the displaying format, but did not worked.

Any thoughts???

Thank you all!!!

[boorgura]

Try this expression:

num(min/60, '#,##0') & ':' & Mod(min,60)

where min is your minutes field or variable.

[Anonymous]

The simpliest way I can think of:
=time(Minutes/24/60, 'hh:mm')

[Anonymous]

Try this:

=interval(avg(FIELDMINUTES)/1440,'h:mm')

(1440 = minutes in a day)

[#5]

Guys, 1st of all, thank you so much for such fast answers!

I tried all out, and there are the results:

What do you all think???

[Anonymous]

Hi Thiago,

Strange that the second line returns 00:26?

Because:

=interval(avg(52)/1440,'hh:mm') returns : 00:52

The rest looks good. Something with the format maybe?

[Anonymous]

Use combination of mine and Dennis:

=

interval(Minutes/24/60, 'hh:mm')

[#8]

Another result table to analyse, adding Michael's last suggestion:

[#9]

Cannot figure out this anomalies... most of the results are correct.

Thank you so much in advance!

[Anonymous · Accepted solution]

This is very strange. I'm trying this formula
=interval(Minutes/24/60, 'hh:mm')
and it gives
-960 -16:00
-1440 -24:00
Looks correct (?)