Hi!
I am trying to calculate duration, in minutes, from a date/time in one column to the time the query is run. Is this best done with a calculated column, or should I use a rule? I sucessfully made a calculated column using DAY_DIFFERENCE to count days, but this should be minutes, since since the "from-time" will have the same date. I the time was 09:00, I would like my calculated column to say 20 if the time is 09:20 when i run the query.
Is there a MINUTE_DIFFERENCE hidden somewhere that I could not find? Any help would be greatly appreciated!