>>Anyone know of an easy way to calculate the number of minutes between 2 dates. I am trying to store the elapsed time between 2 events
>>
>>Thanks
>>
>>Colin
>
>If you have 2 datetime values, the difference will be in seconds and you can divide by 60 to get the minutes.
>
>If you're using 2 date values, the difference will be in dates, and you can multiply by 24*60 to get minutes.

Only if the day is 24*60*60 seconds long. It might be different sometimes, to be precise. You also have to check for time zones

https://www.youtube.com/watch?v=-5wpm-gesOY

:D

And. not to forget, DST.

-5wpm-gesOY