Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
wallerjc
New Contributor III

Take Minutes (mm:ss) from DateTime (dd/mm/yyyy hh:mm)

I have two columns, one is formatted as a date with time dd/mm/yyyy hh:mm:ss

e.g. 02/01/2017 14:00:00

and i have another column formatted as hh:mm like so

00:10

How would I remove 10 minutes, from the 14:00 time in the other column?

I've tried Interval with no luck, and simply taking them doesn't seem to work so thought I'd come to the community for advise.

Thanks

James.

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: Take Minutes (mm:ss) from DateTime (dd/mm/yyyy hh:mm)

Hi James,

try like this

=Timestamp(Timestamp#('02/01/2017 14:00','DD/MM/YYYY hh:mm')-Time('10:00'))

Regards,

Antonio

2 Replies
pathiqvd
Contributor III

Re: Take Minutes (mm:ss) from DateTime (dd/mm/yyyy hh:mm)

Hi,

May be like this,

=date(date(date#('02/01/2017 14:00','DD/MM/YYYY hh:mm'),'hh:mm')-date(date#('10:00','hh:mm'),'hh:mm'),'hh:mm')

Op like:- 14:00 - 10:00 =04:00

Regards,

antoniotiman
Honored Contributor III

Re: Take Minutes (mm:ss) from DateTime (dd/mm/yyyy hh:mm)

Hi James,

try like this

=Timestamp(Timestamp#('02/01/2017 14:00','DD/MM/YYYY hh:mm')-Time('10:00'))

Regards,

Antonio

Community Browser