Calculation Issues

How to Round Driving Times to 15-Minute Intervals in Excel

Algirdas JasaitisAlgirdas Jasaitis Nov 10, 2026 869 views

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.

How to Round Driving Times to 15-Minute Intervals in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Convert Numeric Entries to Time

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.

2
Round to 15-Minute Intervals

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)).

3
Calculate Duration in Minutes

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.

4
Calculate Decimal Hours

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.

Use Excel Functions for Time Conversion, Rounding, and Duration Calculation
Cell Formatting: Make sure to format your start, end, and rounded time cells as 'h:mm'. For the duration calculations (minutes and decimal hours), apply the 'Number' or 'General' format so they display correctly.
Simplify Time Tracking with WPS Spreadsheet

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. 1. Download and Open WPS Spreadsheet: Download and install WPS Office, then open a new Spreadsheet document.
  2. 2. Set Up Your Columns: Create column headers for your driving log: Start Time, End Time, Rounded Time, and Duration.
  3. 3. Apply Time Formats: Highlight your time columns, right-click, select 'Format Cells', and apply the appropriate 'Time' format.
  4. 4. Input the Formulas: Enter the =MROUND() and duration calculation formulas provided above into your cells to automate the driving log.
Fully compatible with Microsoft Excel formulas and .xlsx filesLightweight and fast to open on any deviceBuilt-in templates for timesheets, schedules, and logsFree to use with an intuitive, tabbed interface
microsoft office alternative - wps office

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.