using Interval

[ali_hijazi]

Hello

I got a total number of minutes of 99310

I put the following in text box object and it displays 23:10

=Interval(Time#(99310,'mm'),'hh:mm')

whereas it should be around 1655:10

Am I missing something?

[awhitfield]

Hi Ali,

try this instead:

=Interval(99310/24/60,'hh:mm')

Andy