Group Times into Irregular Intervals with VLOOKUP

In this video, we use the VLOOKUP function to group times into irregular intervals. These intervals are specified in a lookup table so can easily be adjusted in the future. In previous videos, we have used formulas and PivotTables to round and group times in Excel. These methods however have relied on specific intervals such as 30 minutes or 4 hours. In this video, irregular intervals such as 5 hours in the morning, and an 8-hour daytime interval have been set up. The ultimate guide to the VLOOKUP function - https://www.computergaga.com/blog/the-ultimate-vlookup-guide/ 4 ways to use VLOOKUP in Excel - https://youtu.be/EB-rhTyS3Fo Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm