Output total hours

[bobbydave]

num(Interval(Timestamp(Timestamp#(Closed, 'DD/MM/YYYY hh:mm:ss')) - Timestamp(Timestamp#(Created, 'DD/MM/YYYY hh:mm:ss')), 'hh'), '#.##') as [Time Open (hours)],

I'm looking to pull total Open Hours.

Anyone see my error? I'm getting a blank output at the moment.

[fvelascog72]

Hi,

For me is working fine. Maybe Date formats.

Can you share an example of your data?

Saludos.

[Clever_Anjos]

Which format are Closed and Created?

Interval(Closed -Created)  should be enough

[shiveshsingh]

Hi

Try this

=num(interval(num(Timestamp(Closed,'DD/MM/YYYY hh:mm:ss'))- num(Timestamp(Created, 'DD/MM/YYYY hh:mm:ss')),'hh'), '#.##')

[sunny_talwar · Accepted solution]

Have you made sure to check if Closed and Created date were not getting correctly read as timestamps by QlikView? If they were, you could have just used

Num#(Interval(Closed - Created, 'hh'), '##') as [Time Open (hours)],

Also, do you need to convert hour into a number? if not, then Num#() function is not really needed.... but you can use it..

Finally, if you do need TimeStamp#(), then try like below.

Num#(Interval(Timestamp#(Closed, 'DD/MM/YYYY hh:mm:ss') - Timestamp#(Created, 'DD/MM/YYYY hh:mm:ss'), 'hh'), '##') as [Time Open (hours)],