» Rounding Time Intervals to the Nearest Specified Time Increment
CATEGORY - Excel Array Formulas
VERSION - All Microsoft Excel Versions
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"
Book Store:
Recommended Books:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Microsoft Access Version 2002 Step by Step
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Mortgages For Dummies®
No comments have been submitted.
