How to group time by minutes or hours intervals in Excel?
Here is a list of time, and what I want to do is to group time by 3 hours as below screenshot shown, how can I quickly solve it in Excel?
Group time by minutes intervals
Group time by hours intervals
To group time by hours interval, you just need one formula.
Select a cell next to the time, and type this formula =FLOOR(A2,"3:00"), A2 is the time you use, 3:00 is the hours interval, press Enter key and drag fill handle down to apply this formula to cells.
Group time by minutes intervals
If you want to group time by minutes intervals, also can use formulas.
Select a cell next to the time, and type this formula =FLOOR(A2,TIME(0,15,0)), A2 is the time you use, 15 is the minutes interval, press Enter key and drag fill handle down to apply this formula to cells.
Tip: if the formula results are displayed as digits, just need to format them as time format.
Relative Articles
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!