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: 
Not applicable

Interval - Convert seconds into days of 8 hours.

Hi All,

I retrieve data where I have seconds on every line. I'm totalling the rows and using Interval to convert seconds into 'd hh:mm:ss' which is working fine, however the days are taken as 24 hour days where I would like to specify the no of hours per day.

My current interval line is as follows :-

Interval(Interval#(ActualWorkTime,'ss'),'d hh:mm:ss') as ActualTimeH,

which is returning the table below. What do I need to do to the above line to set an 8 hour day?

Thanks

Steve

1 Solution

Accepted Solutions
Not applicable
Author

can't you multiply by 3?

View solution in original post

3 Replies
Not applicable
Author

can't you multiply by 3?

MarcoWedel

=Dual(Div(ActualWorkTime,28800)&' '&Interval(fmod(ActualWorkTime,28800)/86400, 'hh:mm:ss'), ActualWorkTime)

QlikCommunity_Thread_145508_Pic1.JPG

MarcoWedel

Hi,

can you post an example app?

thanks

regards

Marco