» Calculating the Difference Between Hours
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
Enter the following formula into a cell:
=D4-C4+IF(C4D4,1)
The number 1 in the IF formula equals 24 when working with time.
For example, in row 6, the calculation is
6.00 - 20.31+ 24.00 = 9.29.
Book Store:
Recommended Books:
- Positioning: The Battle for Your Mind
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The Basics of Finance: Financial Tools for Non Financial Managers
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
Doesn't work
Jordan
The Forumula doesn't work from the screenshot but if you swap the c3 with d3 and the d3 with b3 it works.
Works!!!
Gilbert
Thanks!!!
I like it
Darlene
This forumula works great - It will ensure accuracy when tracking my hours.
Help on your example
David
what if i wanted to use date and time, say i started on 12 nov at 10.00am and finished on 14 nov at 15:00pm ?
THNX
WORKS
I WAS WONDERING WHAT IF I WANTED TO CALCULATE IN POINT FORM/SYSTEM INCLUDING THE DATES...HOW IS THAT SUPPOSED TO BE DONE?
ram
I wants to calculate working hours between two days
This is different from screenshot.