Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
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.
Go to Solution.
try like this
=Timestamp(Timestamp#('02/01/2017 14:00','DD/MM/YYYY hh:mm')-Time('10:00'))
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