» 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:
- Microsoft Word Version 2002 Inside Out
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Analyzing Markets, Products, and Marketing Plans
- Keys to Reading an Annual Report (Barron's Business Keys)
- Flipping Properties: Generate Instant Cash Profits in Real Estate
No comments have been submitted.
