» 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:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Microsoft Access 2002 for Dummies
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Dictionary of Finance and Investment Terms
- The New Financial Order: Risk in the Twenty-First Century
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
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.