» 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:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Definitive Guide to Excel VBA
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Yes, You Can Time the Market!
No comments have been submitted.
