Group Times in Excel to Specific Intervals - Excel Formula

In this video tutorial, we group times in Excel to specific intervals using an Excel formula. In the video, a list of times is grouped into 6-hour intervals. We then use a PivotTable to summarise the data in these intervals. Although it is possible to group times using PivotTables (video link below), you cannot set specific intervals. The FLOOR function is used in this video to achieve this. Group Times in Excel using PivotTables - https://youtu.be/iCiayB6GrpQ 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 Connect with us!