>>>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.
You wouldn't need to worry about that if your timestamps are in Universal Time.