Tip Printed from ExcelTip.com

---

Rounding Time Intervals to the Nearest Specified Time Increment


Problem:

Columns A & B contain times signed in and out of work.
We want to subtract each Time In from its corresponding Time Out, and round the result to the nearest 30 minutes.

Solution:

Use the ROUND function as shown in the following formula:
=ROUND((B2-A2)/"0:30:00",0)*"0:30:00"