» Creating a Timesheet
CATEGORY - Excel Date and Time
VERSION - All Microsoft Excel Versions
Problem: Creating a timesheet which calculates the number of hours worked each day and a sum of the total hours worked.
Solution:
Create 3 columns containing the following data: Date, Time In, Time Out.
In the 4th column (Number of Hours), use the following formula:
=(C2-B2+(C2
=SUM(D2:D7)
Book Store:
Recommended Books:
- Windows XP All-in-One Desk Reference For Dummies
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Windows XP for Dummies
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Excel 2002 Simply Visual
No comments have been submitted.
