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.

[mdmukramali]

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

[rustyfishbones]

4.16?

[sunny_talwar · Accepted solution]

May be this

Hour(('$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime))) + (Minute(('$(now)' - MIN({<[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}>}StartTime)))/60)

[rustyfishbones]

thats it. thank you.