Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
Hour(('$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime))) + (Minute(('$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime)))/60)
Hi Alan,
it's returning the result in hours and Minutes ...
you want to convert it into Number ?
can you let me know what will be the result of 04:10 when you convert into Number ? // As a Sample
4.16?
May be this
Hour(('$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime))) + (Minute(('$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime)))/60)
thats it. thank you.