field (minus) field = hours:minutes:second

[kkarlste]

Hi

I want to calculate this difference in the hours of this information.

What is formula for calculation?

(ready time) - (notification time) =   dd:hh.mm:ss
26.7.2017 8:41:57 - 26.7.2017 11:30:47 = dd:hh.mm:ss

time stamp style

Valmistumisaika - reagointiaika

[sunny_talwar]

May be this

Interval([ready time] - [notification time], 'D:hh:mm:ss')

[Anil_Babu_Samineni]

May be this?

Interval(Date(Date#([ready time], 'DD.MM.YYYY hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss') - Date(Date#([nontification time], 'DD.MM.YYYY hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss'), 'DD:hh:mm:ss')

[Chanty4u]

try this

interval(date1-date2,'hh')

[kkarlste]

thanks Sunny Tawlar this works very well

Br Kalle

[sunny_talwar]

Awesome, please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny