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

Time Calculations

Hi All

I need to find out how I can multiply a number of hours by expected personnel, to get total hours booked to event.  the calculation to get the Hours are

if(interval(EndTime - StartTime,'hh:mm')<0, interval(Date(EndTime,'ddmmyy')+1 - StartTime,'hh:mm'),interval(EndTime - StartTime,'hh:mm') )as [Total_Hours] and the personnel Expected is a sum of numbers.  so the total booked hours should be 21:00, but I cant workout how I can calculate a time calculation by a number calculation. am i missing something

can anyone help.

Capture.JPG.jpg

thanks in advance

15 Replies
Anonymous
Not applicable
Author

change your expression to

(DDT_Hours)*[Personnel Expected]

  and change the format to Time->hh:mm from the number tab

it works

Not applicable
Author

Hi

i have already changed this and it just shows 00:00 for all values now! are you able to amend the example?

thanks Jebamalai

Anonymous
Not applicable
Author

Hi James

Pls check and let me know

Regards

Jeba

Not applicable
Author


Hi Jeba

The third calculation isnt correct it should show 50:00, it shows 02:00 in the example

regards

James

Anonymous
Not applicable
Author

Oh sorry.

Pfa the updated one

Not applicable
Author

Hi Jeba

that's perfect thanks for your help

regards

James