How do i display the value of the cell as per excel

[WayneQV]

Hi,

I have a cell format in H:MM:SS - This means the excel is displaying for example:

0 hours, 21 mins, 38 secs = 0:21:38 (This is how the excel cell looks like)

I  just want it to display as per the format in excel which is like this. However,  when i load this data and try to display it in qlikview, it shows: 0.0147916666666667

May i know how to display my cell as per how its meant to be? Note: i do not want it to display HH:MM:SS (because i will not have 10 hours. I simply want it as per what it is: H:MM:SS. i do not need to average it or anything, so i just want to display the value only.

Hoping to seek some help

[Or]

Format the measure as an interval using Interval(YourField,'Format') or from the format settings in your object.