+ Reply to Thread
Results 1 to 2 of 2

Creating an Employee Timesheet with Excel

  1. #1
    Registered User
    Join Date
    12-26-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 365
    Posts
    1

    Creating an Employee Timesheet with Excel

    I'm creating an Employee Timesheet and running into problems with the formulas. I was able to get the Date & Day to populate when the Pay period start date is entered but the hours don't add up properly. We don't have sick pay or vacation pay but there are special bonus pay hours (for instance you're sent home early but told you will be paid for that time). I copied these formulas from support threads like this one so I may have gotten them wrong. I'd appreciate it if someone could take a look and see why my formulas don't add up please? I've spent days on this and I'm stuck! thank you so much!
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Creating an Employee Timesheet with Excel

    Looks pretty good to me.

    First, take the *24 out of all formulas in Column I. Time is a decimal.

    Next, update =IF(SUM(I14:K14)=SUM(L14:L28),SUM(I14:K14),"Error!") to include the full range in the SUMs.

    =IF(SUM(I14:K28)=SUM(L14:L28),SUM(I14:K28),"Error!")

    Lastly, change the output format of L28. Choose L28, hit ctrl+1, and go to Custom. Use [h]:mm:ss. This will allow hours to overflow beyond 24.

    Good to go.
    Last edited by daffodil11; 12-26-2014 at 07:50 PM.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating a timesheet for employee's
    By Sammy21 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-29-2012, 03:03 PM
  2. Replies: 2
    Last Post: 01-05-2011, 06:41 PM
  3. employee timesheet with overtime
    By tatehebert1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2008, 11:53 PM
  4. [SOLVED] How do I calculate an employee timesheet in Excel?
    By Raven in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2005, 03:05 PM
  5. How can I add more dates to the employee operations timesheet
    By Daycare in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1