Convert Minutes to Time (HH:MM)

[microwin88x]

Hello,

I have the following number (in minutes):

106,2241116089

I need to convert it to time format (hh:mm).

It would be something like: 01:47

Do you know how to do that?

Thank you!!!

[Anil_Babu_Samineni · Accepted solution]

May be this?

=interval(FieldName/24/60, 'hh:mm')

[Anil_Babu_Samineni]

Or

=Time((25569 + Round(FieldName/1000) / 86400), 'hh:mm')