Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
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
marcus_sommer

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

sunny_talwar

May be this

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

rustyfishbones
Master II
Master II
Author

that returns 62004710.6

sunny_talwar

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

yashdeep
Contributor III
Contributor III

You can use interval function :


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