» Calculating Total Time Worked on a Specific Day
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:
The the TEXT and TRUNC functions as shown in the following formula:
=TEXT(TRUNC(A2)+(B2-A2),""mm""""/""""dd""""/""""yy"""" - """"hh"""" Hrs """"mm"""" Mins """""")
Book Store:
Recommended Books:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Microsoft Windows XP Registry Guide
- Business Analysis with Microsoft Excel (2nd Edition)
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Word 2002: The Complete Reference
No comments have been submitted.
