Formatting time

[drohm002]

Hi All,

I have the number 350.5 in a field called TIME.  It represents 350 hours and 30 minutes.  How can I display this field so it shows as hh:mm, so it would show as 350:30.

Any ideas?  Thank you

[Kushal_Chawda · Accepted solution]

try below

=interval(TIME/24,'hh:mm')