» 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:
- Special Edition Using Microsoft Outlook 2002
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Positioning: The Battle for Your Mind
- Getting to Yes: Negotiating Agreement Without Giving In
- PowerPoint® 2002 For Dummies®
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
