Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Search instead for
Did you mean:
Master II

Convert Time to Integer

Hi All,

I have the following

=TIME('\$(now)' - TIME(MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime),'hh:mm'),'hh:mm')

which returns 04:10

I need to covert this to a number, can you help.

5 Replies

Just remove the time() functions from your expression because each math operation with date/time field will just return the numerical value and not be treated any longer as dual-value. If you need a special formatting, for example to define the decimal-delimiter you need to use num() for it.

- Marcus

MVP

May be this

=('\$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime)) * 1440

Master II
Author

that returns 62004710.6

MVP

Well I was not sure what you wanted initially, but now I do... and I guess you already got the solution on your other post

Contributor III

You can use interval function :

Interval('\$(now)' - TIME(MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime),'hh:mm'),'mm')

Community Browser