» 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 22 Immutable Laws of Branding
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Accounting the Easy Way
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.
