Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Timestamp Issue

I have a list box which contains no of Days......

but its caluculated like 24.05 so  it says 24 days and I am not sure how many hours mins secs that .05 means....

So I changed the number format into Timestamp its displaying    24 1:12:00....

Here is the Issue when I caluculate 24.05 in secs its not same with 24 1:12:00......How to overcome this issue......

how should I change 24.05 into exact days hrs mins and secs.......

1 Solution

Accepted Solutions
MVP
MVP

Re: Timestamp Issue

0.05 means 1/20 of a day (or 5%). A day has 60*24 minutes. 60*24 minutes / 20 = 72 minutes. 72 minutes is 1 hour and 12 minutes --> 1:12:00

3 Replies
MVP
MVP

Re: Timestamp Issue

Could you explain in more detail what you get when you calculate 24.05 in seconds?

I think 1:12:00 is the correct representation in h:mm:ss when 0.05 is a fraction of a day, so 24 1:12:00 should be ok as time interval / duration representing 24.05 as number of days.

Not applicable

Re: Timestamp Issue

Can you Please explain me how .05 is 1:12:00......Thanks

MVP
MVP

Re: Timestamp Issue

0.05 means 1/20 of a day (or 5%). A day has 60*24 minutes. 60*24 minutes / 20 = 72 minutes. 72 minutes is 1 hour and 12 minutes --> 1:12:00

Community Browser