Announcements
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
cancel
Showing results for
Did you mean:
Not applicable

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

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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 (?)

14 Replies
Specialist

Try this expression:

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

where min is your minutes field or variable.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Try this:

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

(1440 = minutes in a day)

Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

Use combination of mine and Dennis:

=

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

Not applicable
Author

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

Not applicable
Author

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

Thank you so much in advance!

Anonymous
Not applicable
Author

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 (?)

Community Browser