» 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:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Mastering Excel 2000 (for beginner)
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
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.