+ Reply to Thread
Results 1 to 6 of 6

Excel Payroll Application

  1. 05-10-2007, 11:33 AM #1
    softuser
    softuser is offline
    Registered User
    Join Date
    05-08-2007
    Posts
    7

    Lightbulb Excel Payroll Application

    Hi
    I am in the process of developing a simple Excel payroll application.
    I have so far managed to get as far as calculation the duration a person has worked each day. But the big piece of the puzzle now is how do you calculate the SUM of the durations worked each day (weekly and monthly).
    I used the simplest method I could think of and did a SUM for the entire week. When I do this it gives me the wrong total.
    How do you tackle this?
    Also is it possible to calculate the total of all hours worked during a particular month or week as well?
    Thanks.
    Reply With QuoteRegister To Reply
  2. 05-10-2007, 11:55 AM #2
    CRGReathouse
    CRGReathouse is offline
    Registered User
    Join Date
    05-10-2007
    Posts
    6
    SUM works pretty well. Can you give us more information, or post a sample sheet?
    Reply With QuoteRegister To Reply
  3. 05-10-2007, 12:35 PM #3
    softuser
    softuser is offline
    Registered User
    Join Date
    05-08-2007
    Posts
    7
    I think I see what is happening here. Basically as the hours get added on and amount to over 24 hours it goes back to zero again. I got this sorted out now. I just had to go Format->Cells and customise field with the format [h]:mm

    Now I am looking to add up all the total hours within a specified range (for the month of May for instance) or for the whole week (Monday - Friday)

    I am currently using SUMIF. I can specify a lower range in the format but I want the range to be the 1st a particular month and the last of that month.
    Last edited by softuser; 05-10-2007 at 01:52 PM.
    Reply With QuoteRegister To Reply
  4. 05-11-2007, 05:20 AM #4
    softuser
    softuser is offline
    Registered User
    Join Date
    05-08-2007
    Posts
    7
    SUMIF worked. Problem solved.

    SUMIF cannot be used to cover the higher and lower ranges. Therefore it had to be used as 2 statements. One minus the other gives the necessary range.
    Reply With QuoteRegister To Reply
  5. 05-19-2007, 04:52 AM #5
    kanwal_deep
    kanwal_deep is offline
    Registered User
    Join Date
    05-19-2007
    Posts
    10
    can u forward the payroll application excel sheet to me? it will be great help to me as i am also preparing the payroll sheet
    Reply With QuoteRegister To Reply
  6. 05-19-2007, 04:57 AM #6
    Simon Lloyd
    Simon Lloyd is offline
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Soft' when summing durations you need to format the cell in a custom format like [h]:mm:ss you can delete the seconds if you wish, using this format allows hours to be counted up rather than a time serial number
    Not all forums are the same - seek and you shall find
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1