Ask Experts Questions for FREE Help !
Ask
    danyelled's Avatar
    danyelled Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Jul 6, 2010, 08:03 AM
    Payroll in Excel
    Can anyone tell me if these formulas are accurate?

    Total time In/Out: =IF(C4< B4, C4+1, C4)-B4

    Total time @ end of pay period: =SUM(D4:D18)*24

    http://2.bp.blogspot.com/_ki9lLuCTZ9...preadsheet.JPG
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jul 6, 2010, 09:18 AM

    If the results work...
    danyelled's Avatar
    danyelled Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Jul 6, 2010, 09:24 AM
    Comment on ScottGem's post
    They seem to work, but when the other manager calculates it with the calculator, she gets a different answer... but my formula seems accurate. Does it look accurate to you?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Jul 7, 2010, 05:25 AM

    We are experimenting with a new interface and it has some issues. Please don't use the Reply button for follow-up, use the Answer This Question options instead.

    What formula does the manager use? What results does she get, How do they differ. The calcs look OK to me.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #5

    Jul 7, 2010, 09:10 AM
    You formula technique is sound. The only change I would suggest is your formula in D4 should already convert the time values into decimal values.

    In D4 and copied down through D18, then formatted as General:

    =(IF(C4< B4, C4+1, C4) - B4) * 24

    Then in D19 a simple:

    =SUM(D4:D18)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Ouickbooks payroll j/e, cash basis using a Payroll Co. [ 5 Answers ]

We use a payroll company to process our payroll. Each payroll they deduct the money for our taxes. If I enter the taxes as a payable, it messes up my books because the money is already deducted with the biweekly payroll. My quarterly reports did not match my QB files and I cannot figure out what...

Payroll and Payroll Tax Expense on an Income Statement [ 2 Answers ]

Is the payroll expense on the Income Statement the gross amount of payroll? What I have seen so far is that it is the gross amount and then the payroll taxes are also listed. Isn't it doubling the amount of expense for the payroll taxes? Thanks for your help!

Payroll company witholding money from uncashed payroll check [ 1 Answers ]

I have a payroll check that is about four years old and the payroll company says that they are in no way obligated to reissue me a check, and that the escheat laws only apply to government office jobs but that is not true. Who would I contact to help me on this problem?

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Payroll and payroll taxes [ 1 Answers ]

I'm completing a project for a high school accounting class. I need to know how to journalize the payment of payroll. I also need to know how to journalize the payment of the payroll taxes.

View more questions Search