» 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 Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Office XP Introductory Concepts and Techniques
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
No comments have been submitted.
