Hour format out of numbers on Excel

[chloe]

Hi,

I have an Excel file that I want to load but the Time column looks as below-

How can I get the hour format out of it by using  Qlik script?

Thanks

[mikaelsc]

maybe time(count_time/(24*3600))

(1 day = 1 unit; 24*3600 seconds in a day) 

[chloe]

It worked! thanks 🙂