Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chloe
Contributor III
Contributor III

Hour format out of numbers on Excel

Hi,

 

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

chloe_0-1613922513712.png

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

 

Thanks

2 Replies
mikaelsc
Specialist
Specialist

maybe time(count_time/(24*3600))

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

chloe
Contributor III
Contributor III
Author

It worked! thanks 🙂