Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasgupta
Creator
Creator

Time Format

Hi All,

I have one straight Table with time format and one field is number of allocated member and i wants to calculate as per example .

Please find the screenshot for same

For example I wants to calculate 150:00:00 * 13 = 1950:00:00

Time for mat excel is hh:mm:ss

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable

You should be able to adapt this to your needs :

          interval ( interval# ( '150:00:00' , 'h:mm:ss' ) * 13  , 'h:mm:ss' )

View solution in original post

2 Replies
Anonymous
Not applicable

You should be able to adapt this to your needs :

          interval ( interval# ( '150:00:00' , 'h:mm:ss' ) * 13  , 'h:mm:ss' )

vikasgupta
Creator
Creator
Author

Thanks Bill for your quick help 🙂