VB.NET || How To Generate Hourly Time Range With Minute Interval Using VB.NET

The following is a module with functions which demonstrates how to generate an hourly time range with minute interval between a start and end time using VB.NET.

The function demonstrated in this page generates a time value list containing the time from a starting hour to an ending hour, separated by a minute step. The starting and ending hour is an integer from 0 through 23 representing the 24 hour period of the day, and the minute step can be any minute interval, including decimal values.

The starting and ending hours can also be flipped, indicating that the results should be returned in descending order.

An optional parameter also exists which allows to tune the results. When the range is in ascending order, the parameter indicates that the results should exclude/include the entire ending hour. When the range is in descending order, the parameter indicates that the results should exclude/include the entire starting hour.


1. Ascending Time Range – Minute Interval – Default

The example below demonstrates the use of ‘Utils.DateRange.GetTimeRange‘ to get the time range with a minute interval in ascending order.

In this example, the default options are used, which excludes the full ending hour from the results.


2. Descending Time Range – Hourly Interval – Default

The example below demonstrates the use of ‘Utils.DateRange.GetTimeRange‘ to get the time range with a hourly interval in descending order.

In this example, the default options are used, which excludes the full starting hour from the results.


3. Ascending Time Range – Minute Interval – Include Full Hour

The example below demonstrates the use of ‘Utils.DateRange.GetTimeRange‘ to get the time range with a minute interval in ascending order.

In this example, the optional parameter is used, which includes the full ending hour from the results.


4. Descending Time Range – Hourly Interval – Include Full Hour

The example below demonstrates the use of ‘Utils.DateRange.GetTimeRange‘ to get the time range with a hourly interval in descending order.

In this example, the optional parameter is used, which includes the full starting hour from the results.


5. Utils Namespace

The following is the Utils Namespace. Include this in your project to start using!


6. More Examples

Below are more examples demonstrating the use of the ‘Utils‘ Namespace. Don’t forget to include the module when running the examples!

QUICK NOTES:
The highlighted lines are sections of interest to look out for.

The code is heavily commented, so no further insight is necessary. If you have any questions, feel free to leave a comment below.

Was this article helpful?
👍 YesNo

Leave a Reply