Convert calculated number to time

[tappij2012]

Hi,

I want to convert a calculated number  into a time-format in a table.

For Example:

I've calculated a number: 128, which means 128 minutes.

In time-format it will be: 02:08 [hh:mm].

How can I make that work?

[MK_QSL · Accepted solution]

=Time(Time#(Num#('128','#0'),'m'),'hh:mm')

[its_anandrjs]

Hi,

You can convert this way

Load

Time( Time#( num(NumberField),'m'),'hh:mm') as NUmField

From Location;

Ex:- any any text box write this expression

=Time( Time#( num('128'),'m'),'hh:mm')

Regards

Anand

[tappij2012]

Now I've seen that it count until 23:59 [hh:mm].

After that it counts from 0.

For example:

number 1439 give as result 23:59 [hh:mm]
number 1441 give as result 00:01 [hh:mm] (and not like I wish 24:01 [hh:mm])

How can I solve that?

Regards Robin

[anbu1984]

=Floor(1441/60) & ':' & Num(Mod(1441,60),'00')

[MK_QSL]

=interval(1441/1440,'hh:mm')