# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Contributor

## Calculating time diff

Hi All,

How to Calculate time diff .

Ex: To-From as Duration

Thanks,

Krishna

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Honored Contributor III

## Re: Calculating time diff

PFA!

=interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')

Regards,

AS

3 Replies
Highlighted
Honored Contributor III

## Re: Calculating time diff

PFA!

=interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')

Regards,

AS

Highlighted
Contributor

## Re: Calculating time diff

Hi Amit,

How to Calculate 24 - interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')

Thanks,

Krishna

Honored Contributor III

## Re: Calculating time diff

Like this???

=interval(time('24:00:00', 'hh:mm:ss')-

interval(time([      To  ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss'))

Thanks,

AS