# Round the time in cell A1 to the nearest 15 minutes (quarter of an hour) : TIME « Date Time functions « Microsoft Office Excel 2007 Tutorial

Home
Microsoft Office Excel 2007 Tutorial
 1 Introduction 2 Editing 3 Format Style 4 Table 5 Chart 6 Formula 7 Workbook Worksheet 8 Wordart Clip Art Shape Picture 9 PivotTable PivotChart 10 Data Analysis 11 Macro ActiveX Add in 12 Security 13 Collaboration 14 Database functions 15 Date Time functions 16 Engineering functions 17 Information functions 18 Logical functions 19 Lookup Reference functions 20 Math Trigonometry functions 21 Statistical functions 22 Text functions
 Microsoft Office Excel 2007 Tutorial » Date Time functions » TIME
15.12.7.Round the time in cell A1 to the nearest 15 minutes (quarter of an hour)
 `Input the formula: =ROUND(A1*24/0.25,0)*(0.25/24)`
 15.12.TIME 15.12.1. TIME(hour,minute,second) returns the serial number of a particular time 15.12.2. Displaying Any Time 15.12.3. Calculating the Difference between Two Times 15.12.4. Add two hours and 30 minutes 15.12.5. Round the time in cell A1 to the nearest minute: 15.12.6. Round the time in cell A1 to the nearest hour: 15.12.7. Round the time in cell A1 to the nearest 15 minutes (quarter of an hour) 15.12.8. To round a time to the nearest 30 minutes, change 0.25 to 0.5