formating

[Anonymous]

Hi,

I have a text object in my model which contains the formula '=only(FieldTime)'. It returns the value 250,25.

I'd like to set the time format for this formula so that I can get a result 4:10 (4 hours and 10 minutes).

How can I do it?

Thank you in advance,

Larisa

[sunny_talwar · Accepted solution]

Try like this:

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

UPDATE: For your scenario -> =Interval(Only(FieldTime)/(60*24), 'hh:mm')

[Anonymous]

Thank you!