Results 1 to 7 of 7

Thread: Excel Spreadsheet to calculate weekly wages

  1. #1
    Full Member
    Join Date
    Jun 2015
    Location
    Umkomaas
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Spreadsheet to calculate weekly wages

    Good Morning,

    I would like to use an excel spreadsheet to generate weekly wages. I would like to add hours (example 2hours 42min + 5hours 39minutes = 8hours 21minutes BUT if I type in 2.42 and 5.39 into a cell and add it gives me 7.81which is incorrect and would cause me to underpay my staff) How can I do this?

  2. #2
    Full Member
    Join Date
    Jun 2015
    Location
    Umkomaas
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Issue has been resolved :-)

  3. #3
    Moderator IanF's Avatar
    Join Date
    Dec 2007
    Location
    Jhb
    Posts
    2,679
    Thanks
    197
    Thanked 529 Times in 405 Posts
    Dientjie
    How did you do this, I have never managed in excel so gave up as it was quicker for me to do manually.
    So teach us the tricks.
    Only stress when you can change the outcome!

  4. #4
    Suspended
    Join Date
    Mar 2013
    Location
    Had enough
    Posts
    3,358
    Thanks
    114
    Thanked 213 Times in 201 Posts
    I have got one
    Just break up your hours and minutes into two different cells, then use your formulas in different cells to get your totals hours and minutes.
    The minutes cell you have to basically divide by 60 to get hours.
    You can then put in your hourly rate or weekly rate and less your uif/paye in two separate cells and get
    your total at the end.

  5. #5
    Full Member
    Join Date
    Jun 2015
    Location
    Umkomaas
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good Morning Ian,

    In the cell you want to put the hours in select format cells - on the number tab select "custom" and look for [h]:mm:ss. Type in your hours (example 48:45 -48hours 45 minutes) Make sure all your cells are in this format and sum - viola!!

    If you want to multiply the total hours with an hourly rate make sure your formula says =A1 (total hours worked)*A2(rate per hour)*24

    If you need help let me know....

  6. #6
    Moderator IanF's Avatar
    Join Date
    Dec 2007
    Location
    Jhb
    Posts
    2,679
    Thanks
    197
    Thanked 529 Times in 405 Posts
    Dientjie you beaut, that worked for calculating minutes per KM in excel. I couldn't figure that out.
    Only stress when you can change the outcome!

  7. #7
    Full Member
    Join Date
    Jun 2015
    Location
    Umkomaas
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Glad I could help :-)

Similar Threads

  1. Easyfile CSV format document and example spreadsheet
    By Laurence Lombard in forum Tax Forum
    Replies: 14
    Last Post: 27-Nov-18, 04:45 AM
  2. Excel spreadsheet for VAT reconciliation
    By JaunetteK in forum Accounting Forum
    Replies: 17
    Last Post: 07-Jun-17, 07:03 AM
  3. Formula to calculate staff costs against profit
    By Jacky in forum Accounting Forum
    Replies: 4
    Last Post: 23-Oct-14, 09:17 AM
  4. Excel spreadsheet - to convert to CSV for Easyfile import
    By Christel in forum Technology Forum
    Replies: 5
    Last Post: 16-Apr-13, 01:08 PM
  5. Weekly wages vs Monthly w.r.t. tax workings & increase (pro rata)
    By Christel in forum Labour Relations and Legislation Forum
    Replies: 5
    Last Post: 07-Oct-12, 07:55 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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