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!!!

[#2]

It is correct indeed... looks like the anomalies are related to big numbers...

Would there be a difference between using the formulas in the LOAD statement and in the charts?

Thx!!!!!!!!

[Anonymous]

It should work the same way in charts and script.

[#4]

I'll look deeper into it to find out the anomalies... I'll be back when news come up.

Michael, there's any chance of this being a bug in QV... I'm running 8.5 here.

Thank you very much for your time and tips!

My best wishes!

[#5]

hi,

this is working for me, but, how can I convert large numbers  to dd:hh:mm ?

Thanks

[mferrarini88]

thank you