MinutesBetween()

Purpose

To determine the number of minutes between two date/time values.

Syntax

MinutesBetween( <dDate1>, <cTime1>, <dDate2>, <cTime2>, <lWeekEnds> ) nNumber

Argument

<dDate1> The starting date

<cTime1> The starting time as character string formatted as "hh:mm:ss" (24 hour format)

<dDate2> The ending date

<cTime2> The ending time as character string formatted as "hh:mm:ss" (24 hour format)

<lWeekEnds> A logical indicating whether or not to count weekends.

Returns

MinutesBetween() returns the number of minutes between <cTime1> on <dDate1> and <cTime2> on <dDate2>.  The first date/time value must be the smaller of the two.