Results 1 to 7 of 7

Multiplying total hours worked by pay rate to get total monthly pay

Threaded View

  1. #1
    Registered User
    Join Date
    05-03-2010
    Location
    Netanya, Israel
    MS-Off Ver
    Excel 2008
    Posts
    3

    Multiplying total hours worked by pay rate to get total monthly pay

    I have created a simple times sheet. When I multiply the total number of hours worked by the pay rate it for some reason treats the pay rate as a rate for 24 hours, ie. if its 36 hours multiplied by $10 it gives me $15 as the answer, when of course it should be $360.

    Now, I can solve it by multiplying the result by 24, but can someone please explain why this is happening and what mistake I might be making?
    Attached Files Attached Files
    Last edited by jonorose; 05-03-2010 at 11:50 AM. Reason: I added the file

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1