» 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:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Windows XP Pocket Reference
- Special Edition Using Microsoft Office XP
- The Financial Numbers Game: Detecting Creative Accounting Practices
No comments have been submitted.
