|
» Calculating the Difference Between Hours
CATEGORY: Excel Time |
VERSIONS: 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 |
  |
|
RATING:
3.12
VIEWS: 138818 |
||||
Doesn't work
Jordan wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
Thanks!!!
I like it
Darlene wrote on December 31, 1969 19:00 EST
This forumula works great - It will ensure accuracy when tracking my hours.
Help on your example
David wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
I WAS WONDERING WHAT IF I WANTED TO CALCULATE IN POINT FORM/SYSTEM INCLUDING THE DATES...HOW IS THAT SUPPOSED TO BE DONE?
ram wrote on December 31, 1969 19:00 EST
I wants to calculate working hours between two days
Sponsors:
 |
Book Store:
Recommended Books:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Analyzing Markets, Products, and Marketing Plans
- Seven Habits Of Highly Effective People
- Business Analysis with Microsoft Excel (2nd Edition)
- Flipping Properties: Generate Instant Cash Profits in Real Estate
Related MS EXCEL TIPS:
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.
This is different from screenshot.