|  

» Calculating the Difference Between Hours

CATEGORY - Excel Time VERSION - All Microsoft Excel Versions
To calculate an employee's working hours:

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.
Screenshot // Calculating the Difference Between Hours
Calculating the Difference Between Hours


Book Store:

VIEW ALL BOOKS

Recommended Books:

Print Tip
Add to My Tips
Rate This Tip
12 34 5
Rating: 3.12     Views: 151324
I make a mistake?
Gianfranco
Excuse me, we lost > in the formula or not?
This is different from screenshot.
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
Click here to post comment
For Registered Users
Click here to Regiser
For Guest
Name
Comment Title
Comments


Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation