» Calculating Total Time Worked on a
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Columns A & B contain the dates and times that a person signed in and out of work.
We want to create a new column containing the date and the calculated time that was worked on that day.
Solution:
Use the TEXT and TRUNC functions as shown in the following formula
=TEXT(TRUNC(A2)+(B2-A2),"mm""/""dd""/""yy"" - ""hh"" Hrs ""mm"" Mins """)
The above formula performs the desired time calculation and uses the TRUNC function to return the relevant date.
Book Store:
Recommended Books:
- Word 2002: The Complete Reference
- Microsoft Windows XP Registry Guide
- The Ernst & Young Business Plan Guide
- How to Read A Financial Report
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
No comments have been submitted.
