» 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:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Finance and Accounting for Nonfinancial Managers
- Windows XP Annoyances
- Special Edition Using Microsoft Word 2002
- Microsoft Excel 2002 Simply Visual
No comments have been submitted.
