» Rounding Hours Up
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Listed in columns B & C are the times that each employee in column A signed in and out of work today.
We want to calculate the number of hours each employee worked, rounded up to the nearest hour.
Solution:
Use the CEILING functions as shown in the following formula:
=CEILING((C2-B2)*24,1)
Book Store:
Recommended Books:
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Guide to Financial Reporting and Analysis
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Investments + S&P Card + Powerweb + StockTrak discount coupon
No comments have been submitted.
