Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
How to convert a value from minutes to hours in the hh: mm format?
Example
field: 65 (minute)
result: 01:05
May be this:
Time(Time#(Field, 'm'), 'h:mm') as Field
try this not tested
=interval(Minutes/24/60, 'h:mm')
its working check it
=interval(Field/24/60, 'h:mm')
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!
Is 17.31 not the right result?