Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
skzwane01
Contributor III
Contributor III

Convert hours to date

Hi,

I have an excel data file which has the below data and I would like to convert the data into date format.

TriggerDate
07:06.9
18:02.4
23:11.4
21:34.0
52:13.9
29:33.5

 

Please kindly assist.

 

Kind Regards,

Sanele Zwane

Labels (2)
2 Replies
mrtinsjoao
Contributor III
Contributor III

In Script Date(TriggerDate,'DD/MM/YYYY') as TriggerDate
Vegar
MVP
MVP

Which output do you expect from the TriggerDate samples above?