MinutesIntoWeek (Function)
DisclaimerThe MinutesIntoWeek function returns the number of minutes since 12 am Sunday.
Syntax
MinutesIntoWeek(XDay, XTime))
Returns (Integer)
The total minutes from 12 am Sunday to the specified XDay and XTime.
Parameters
|
Name |
Type |
Description |
|
XDay |
Numeric |
Sets an integer value for the day of the week. Enter 0 for Sunday, 1 for Monday, through 6 for Saturday. |
|
XTime |
Numeric |
Specifies the time in 24 hour HHMM format. For example, enter 2150 for 9:50 pm. |
Example
Assigns to Value1 the number of minutes between Sunday at 12:00 am and Monday at 10:20 am, which is 2060 minutes.
Value1 = MinutesIntoWeek(1, 1020);