How to Round Driving Times to 15-Minute Intervals in Excel
Question details
The user needs to create a spreadsheet to log student driving sessions, round times to 15-minute intervals, and calculate the total duration in both minutes and decimal hours.

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Creating a driving session tracking log for students with specific time rounding, calculation, and data entry requirements.
- Observed behavior
- The goal is to easily enter times (like 845), convert them to proper time formats, round them to the nearest quarter-hour, and accurately calculate session lengths.
Ensure that the cells where you will enter or display times are formatted correctly as Time (e.g., h:mm), and that your duration output cells are formatted as Numbers or General.
Use Excel Functions for Time Conversion, Rounding, and Duration Calculation
A complete method using TIME, MROUND, and basic arithmetic to convert numeric time entries, round to 15 minutes, and compute the session duration.
Excel handles time as a fraction of a 24-hour day. By using specialized time functions alongside basic math, you can automate conversions, round precisely to the nearest 15 minutes, and output durations that are easy to read.
If you prefer entering times as plain numbers without colons (e.g., typing 845 for 8:45 AM), use the formula =TIME(INT(A2/100),MOD(A2,100),0) to convert it into a valid Excel time format.
To round a valid time cell to the nearest quarter-hour, use the MROUND function. Select an empty cell and enter the formula =MROUND(A2,TIME(0,15,0)).
To find the total minutes elapsed, subtract the start time from the end time and multiply by 1440 (the number of minutes in a day). For example, use =(B2-A2)*1440.
To find the duration in hours as a decimal, subtract the start time from the end time and multiply by 24. For example, use =(B2-A2)*24.

Directly Input Decimal Durations for Simplified Tracking
If exact start and end times aren't strictly required for your records, entering the duration directly saves calculation steps.
Easily Create Driving Logs in WPS Spreadsheet
WPS Spreadsheet is a powerful, free tool for all your data tracking needs. It fully supports standard spreadsheet formulas like MROUND and TIME, making it easy to create driving logs, timesheets, and complex calculations seamlessly.
- 1. Download and Open WPS Spreadsheet: Download and install WPS Office, then open a new Spreadsheet document.
- 2. Set Up Your Columns: Create column headers for your driving log: Start Time, End Time, Rounded Time, and Duration.
- 3. Apply Time Formats: Highlight your time columns, right-click, select 'Format Cells', and apply the appropriate 'Time' format.
- 4. Input the Formulas: Enter the =MROUND() and duration calculation formulas provided above into your cells to automate the driving log.

Frequently Asked Questions
Why is my duration calculation showing a strange time instead of a number?
Spreadsheet software might automatically format your formula result as a Time because the input cells are times. Right-click the result cell, select 'Format Cells', and change the category to 'General' or 'Number' to see the duration correctly.
Can I always round up to the next 15 minutes instead of the nearest?
Yes. If you need to strictly round up regardless of the closest increment, use the CEILING function instead of MROUND: =CEILING(A2, TIME(0,15,0)).
How does multiplying by 1440 convert time to minutes?
Spreadsheets store dates and times as decimal numbers representing days. Since there are 24 hours in a day and 60 minutes in an hour, 24 * 60 = 1440. Multiplying the time fraction by 1440 gives you the total minutes.
Will these time formulas work if a driving session crosses midnight?
Standard subtraction (B2-A2) will result in a negative number or an error if the session crosses midnight. To fix this, use the formula =MOD(B2-A2, 1) before multiplying by 24 or 1440.




