» 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:
- Microsoft Office XP Introductory Concepts and Techniques
- The Guide to Understanding Financial Statements
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Financial Risk Manager Handbook, Second Edition
- The Analysis and Use of Financial Statements
- Writing Excel Macros with VBA, 2nd Edition
No comments have been submitted.
