unityconvert minute hour

[fmazzarelli]

Hi Community,

How to convert a value from minutes to hours in the hh: mm format?
Example
field: 65 (minute)

result: 01:05

[sunny_talwar]

May be this:

Time(Time#(Field, 'm'), 'h:mm') as Field

[Chanty4u]

try this not tested

=interval(Minutes/24/60, 'h:mm')

[Chanty4u]

its working check it

=interval(Field/24/60, 'h:mm')

[fmazzarelli]

Hi,

if i use a value as 536731 using your formula I receive uncorrect result.

What's wrong?

Time(Time#(sum([MINUTI TOTALI]), 'm'), 'hh:mm')

using a value as 536731 the result is 17:31

Uhm!

[sunny_talwar]

Is 17.31 not the right result?