Convert Time to Integer

[rustyfishbones]

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.

[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]

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]

You can use interval function :

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