Difference between 2 time stamps in mintues

[adoremars]

Hi.

I have two time stamp fields like Oct 5, 2009 2:50:06 PM and Oct 5, 2009 4:58:06 PM. Need to find the difference between these two fields and the output should be in minutes (number). Also i use a prompt having the selection criteria's like <20, between 20 and 60 etc in the prompt page, so the difference should be a number.

Any help to achieve this is appreciated :)

thanks

[billylodz]

(extract(hour,[Data Item2])*60+extract(minute,[Data Item2]))-(extract(hour,[Data Item1])*60+extract(minute,[Data Item1]))+_days_between([Data Item1],[Data Item2])*1440

[adoremars]

Thanks a lot Billy...