» 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:
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Access 2002 for Dummies
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
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.