Convert Seconds into Hours and Minutes

[Channa]

I am getting time difference in seconds from data base i need to convert into HH:MM

[agni_gold]

https://community.qlik.com/t5/QlikView-App-Development/convert-seconds-in-h-mm-ss/td-p/223722

[Channa]

Thank you bro,

i don't want to show seconds just HH:MM

i use those expressions it is showing like 12:76 ..i dont want to show 76 it should be below 60

[sunny_talwar]

Would you be able to share an image of what you have right now? You can try something like this if you have seconds like this 360 and you want to show 00:06

=Interval(Interval#(360, 's'), 'hh:mm')

[Channa]

Sunny thank you

it works i have to add KPI color like more than 2 hours i want to show as red color

can you please help me with KPI color

[sunny_talwar]

Should be like this

If(Interval#(FieldName, 's') > MakeTime(2), Red())

[Channa]

i tried 

=If(Interval#(AVG(VOYAGE_ARR_TO_CONTAINER_DISCHARGE), 's') > MakeTime(2), Red(),Green())

08:22 

showing in Green color it should be red

[sunny_talwar]

What value do you get for Avg(VOYAGE_ARR_TO_CONTAINER_DISCHARGE)?

[Channa]

i get seconds between tow dates

[sunny_talwar]

Hahahaha what is the value my friend? Is it giving you a value of less than 7200 (60*60*2)